Re: T-SQL : Unknown number of input parameters
From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/14/04
- Next message: Andrew J. Kelly: "Re: How to prevent queries showing up in Profiler?"
- Previous message: Grant Case: "Re: T-SQL : Unknown number of input parameters"
- In reply to: Jaco: "T-SQL : Unknown number of input parameters"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 14 Mar 2004 14:33:46 -0500
I suggest using a start range and end range, and calculating for all the
dates between x and y. Or, have your program call the stored procedure
multiple times.
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Jaco" <anonymous@discussions.microsoft.com> wrote in message news:CBCE0EFF-691C-4EA9-A68C-4FEA56EBDE4F@microsoft.com... > Hi, > > When I will start a query, I want to ask the user to input some parameters (dates). > My second problem is that the user have to input minimal 2 dates (input parameter), but he may choose the number of input parameters. So, in my programm I don't know before the number of input parameters. > > > Purpose is for each date (input parameter) I have to calculate the balance of an account on that date. So, the user can ask it for 2 days or for 10 days. > > Somebody have an idea to do this? > Thanks, > Jaco >
- Next message: Andrew J. Kelly: "Re: How to prevent queries showing up in Profiler?"
- Previous message: Grant Case: "Re: T-SQL : Unknown number of input parameters"
- In reply to: Jaco: "T-SQL : Unknown number of input parameters"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
