No announcements
Found 2443425 threads
-
1 VotesHow are PQ parameters (objects) passed to functions ?
M values are immutable, so the difference between pass-by-value and pass-by-reference are largely an implementation detail. Why are you asking?Answered | 1 Replies | 376 Views | Created by Nin Sute - Saturday, November 5, 2016 9:36 AM | Last reply by Curt Hagenlocher - Monday, November 7, 2016 4:26 PM
-
0 Votes
How Structured Parameters are passed to SQL Server internally
I have read about the usage of the Table Value Parameters in SQL Server 2008 and i am curious to know how the Data of the StructuredType is passed to the ...Unanswered | 4 Replies | 4625 Views | Created by durga prasad p.v_ - Monday, March 1, 2010 10:32 AM | Last reply by durga prasad p.v_ - Friday, March 5, 2010 6:13 AM -
1 Votes
How to examine what parameters are being passed to functions / stored procs that are running using SQL Server Profiler?
24 hours). The stored procedure calls various scalar and tabled valued functions. By seeing the parameters being passed to these functionsAnswered | 7 Replies | 5571 Views | Created by BSDZ - Sunday, September 13, 2009 9:09 PM | Last reply by BSDZ - Wednesday, September 16, 2009 7:54 AM -
6 Votes
PQ Salesforce objects filter logic
Hi Curt, I think the custom filtering on salesforce table/reports are important. We are using the PQ to extract the data from salesforce on the daily bases and it ...Answered | 3 Replies | 839 Views | Created by greenguy13 - Monday, February 23, 2015 7:13 AM | Last reply by George Qiao - Monday, March 16, 2015 5:35 AM -
1 Votes
Passing objects into functions
$lastwritetime and $length are parameters of your function, but do not automatically recieve their values from the objects being passed. replace ...Answered | 4 Replies | 21230 Views | Created by Keith Work - Tuesday, July 31, 2012 11:25 PM | Last reply by Keith Work - Wednesday, August 8, 2012 5:29 PM -
0 Votes
RE-Using passed parameters
with available options. I would like to be able to choose from the selection boxes and replace the initial (passed parameters) B and C would ...Answered | 5 Replies | 10388 Views | Created by Trentino - Friday, December 30, 2005 1:50 AM | Last reply by Parth Rawal - Tuesday, January 27, 2009 7:43 AM -
0 Votes
pq
Hi, Thank you for visiting our forum. The forum that you posted is the English only forum for Microsoft Office. To avoid any misunderstanding that may ...Unanswered | 1 Replies | 700 Views | Created by gabriel luan - Friday, May 9, 2014 9:37 PM | Last reply by George123345 - Monday, May 12, 2014 1:30 AM -
1 Votes
Passed SP parameters against local parameters
is optimized for these parameter values. When you assign the parameters to local variables and then use the local variables in the query SQL Server does not sniff the local variable ...Answered | 6 Replies | 3914 Views | Created by Piotr Katny - Friday, January 15, 2010 2:53 PM | Last reply by Plamen Ratchev - Friday, January 15, 2010 3:23 PM -
0 Votes
Hiddenm parameters in functions
I am using a custom function in the query to define a dataset for a report. The function has parameters that are defined in the query. When testing the function ...Answered | 1 Replies | 3779 Views | Created by RSforK12 - Tuesday, December 7, 2010 11:37 PM | Last reply by Jerry Nee - Thursday, December 9, 2010 2:43 AM -
0 Votes
Returning objects from functions
There is no simple way to cast or convert a COm Object in PowerShell. You have to create a custom Object and then add/map the parameters + values ...Answered | 4 Replies | 2849 Views | Created by Evgeny Fedorov - Wednesday, September 26, 2012 6:27 AM | Last reply by Peter Kriegel - Wednesday, September 26, 2012 7:16 AM -
0 Votes
How to verify parameters passed from dropbox in the report
Hello guys, I have a report with some parameters passed through dropbox. Is there a way to verify what values are ...Answered | 3 Replies | 5514 Views | Created by fasttrack - Friday, March 25, 2011 10:38 AM | Last reply by Jerry Nee - Saturday, March 26, 2011 4:38 AM -
0 Votes
In SSRS 2008, how are parameters passed down to the DatSet Query... or can they?
Duplicate postUnanswered | 7 Replies | 672 Views | Created by Bobby Lawrence - Thursday, February 7, 2019 9:01 PM | Last reply by Klaus Bilger - Friday, February 8, 2019 10:11 AM -
1 Votes
CLR Functions with Optional Parameters
Unfortunately, functions with default parameters are not currently supported by SQL CLR, so you'll probably have to always pass in the ...Answered | 3 Replies | 23445 Views | Created by Glenn Wellington - Friday, July 28, 2006 4:53 PM | Last reply by nielsb - Sunday, June 17, 2007 1:29 PM -
0 Votes
Parameters not getting passed
down next to the field. Now i dragged the field from the dataset and placed it inside the list, now i went to the tablix properties and created a filter. I repeated this ...Answered | 2 Replies | 4302 Views | Created by Novicessrs - Sunday, February 3, 2013 11:07 PM | Last reply by Novicessrs - Monday, February 4, 2013 2:26 PM -
0 Votes
Parameters are not being passed correctly in stored procedure
the below query the parameters are not passed to the stored procedure. i want to be able to select either of the 4 stored procedures in the ...Answered | 6 Replies | 4354 Views | Created by SBolton - Tuesday, August 30, 2011 3:34 PM | Last reply by SBolton - Friday, September 2, 2011 3:15 PM -
0 Votes
How to Identify the count , If multiple parameters are passed using Pipe Delimited string
Hi NaveenCR, According to your description, you used pipe delimited multi-value parameter in the report, you want to know how many values passed ...Answered | 5 Replies | 749 Views | Created by NaveenCR - Wednesday, January 28, 2015 6:44 PM | Last reply by NaveenCR - Thursday, January 29, 2015 6:07 PM -
0 Votes
all the objects are not being passed through the pipeline
This would be how to do this in PowerShell V2 and later. $mailprops = @{ From = 'Queues.Exchange@company.com' To = ...Answered | 2 Replies | 358 Views | Created by Tiri2014 - Tuesday, August 15, 2017 5:44 PM | Last reply by jrv - Tuesday, August 15, 2017 6:23 PM -
1 Votes
Howto pass variables to parameters to functions?
> BCP.exeAnswered | 5 Replies | 1131 Views | Created by Jay Kidd - Wednesday, October 22, 2014 11:48 PM | Last reply by - Monday, November 3, 2014 8:05 AM -
1 Votes
More SSRS Lookup functions - can the report parameters be passed to query of the referenced dataset?
across to the cube and review the exact MDX statements being sent across. One of the parameters was getting set to the same as another in the query used by ...Answered | 2 Replies | 771 Views | Created by shiftbit - Tuesday, September 29, 2015 8:43 PM | Last reply by shiftbit - Wednesday, September 30, 2015 1:24 PM -
3 Votes
MultiValue parameters passed between report
statement. For more information about Using Single-Value and Multivalue Parameters, please refer to the article below:Answered | 11 Replies | 2800 Views | Created by Augusto C - Tuesday, July 19, 2011 4:34 AM | Last reply by Elvis Long - Friday, July 22, 2011 8:10 AM - Items 1 to 20 of 2443425 Next ›
No announcements
