Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts

Friday, March 30, 2012

Max no. of parameters in functions

Hi,
Can anybody tell me the max no of parameters that we can use in a single
UDF?
Thanks!!BOL:

A function can have a maximum of 1,024 parameters.|||BOL:

A function can have a maximum of 1,024 parameters.
Thanks a lot Sean.|||Hi,
Can anybody tell me the max no of parameters that we can use in a single
UDF?
Thanks!!Half of me shudders every time I see a post about SQL Server's maximum capacity, and the other half tingles with excitement at the future potential consulting income.|||anybody ever made a UDF with that many no of parameters ?|||anybody ever made a UDF with that many no of parameters ?|||anybody ever made a UDF with that many no of parameters ?

Plz listen,don't blame me for that,I found the question in an online test for the MCDBA 70-229 exam (Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition).:D

and the other half tingles with excitement at the future potential consulting income.

Batman is an experienced person and has all the future insights which protect him from danger. :D ;)|||not blaming you for anything ... i was just thinking aloud ;)|||not blaming you for anything ... i was just thinking aloud ;)
yea,there you are,I too was running in that same road a few hours ago.:D :D|||I am a late riser ... mostly go out on evening walks :D

Monday, March 26, 2012

MAx # if Report Params?

Does anyone happen to know if there is a maximum Number of report parameters
supported?
thanks
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.There is no limit on the number of report parameters.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uvAlddBRFHA.3140@.tk2msftngp13.phx.gbl...
> Does anyone happen to know if there is a maximum Number of report
> parameters
> supported?
> thanks
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
>

Friday, March 23, 2012

Matrix subtotals jump to subreport?

I have a complex issue. I have a matrix that has a cell that jumps the user to a subreport sending parameters. Well the report also has subtotals compliments of the matrix. Well those subtotals also jump to the subreport sending *first* parameters. I don't want the subtotals tojump anywhere! How do I disable navigation on the subtotal row? Crazy!

Have you found a solution to this? I am having the same problem.