Maximum number of parameters?

[redlam]

Does anyone know if there is a maximum number of parameters that can be sent in a stored procedure?  I need to be able to accept up to 100 parameters from a customer order form.  Is this possible in SQL 7?

 

[foxdev]

1,024 is the maximum number of stored procedure parameters, so it looks like you're in luck!<br><br><i>source: BOL, topic: Create Procedure (T-SQL)</i> <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[redlam]

Thank you.&nbsp;&nbsp;I had searched BOL - not sure how I missed this!!&nbsp;&nbsp;

 

[foxdev]

Don't feel bad; it took me about 5 topics to find it as well, which is why I included the topic name. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[gopalg]

Hi,
I'm wondering if there was any resolution for this XIRR calculation in SQL because I need this now as well. If someone could get back to me with suggestions I would be obliged.

Thanks
Gopal