But I have more than one stored procedure to get executed. How can we get another StoredProcedure name as variable to pass.

I can`t get it as the stored procedure names are in a table.

Below is the SQL and attached is the SSIS pkg. The pkg runs fine for one stored procedure...

Yes. Same format with Pipe | as delimiter.

mickyT (9/22/2013)

---

Hi

I think this covers what you want to do. I suspect the performance will be poor.

WITH groupit AS (

-- Group up the Depts on data

SELECT CID, CDate, Dept,

ROW_NUMBER()...

J Livingston SQL (9/22/2013)

---

etirem (9/22/2013)

---

Sorry! May be I`m not explaining it properly.

One more CID=333 is added below SQL.

...

Sorry! May be I`m not explaining it properly.

One more CID=333 is added below SQL.

IF OBJECT_ID('Tempdb..#tTable') IS...

etirem (9/21/2013)

---

The Groups are created based on CDate and Dept.

For the CID, the CDate is in ASC order and if Dept=C and the next row is Dept=C...and next row is...

The Groups are created based on CDate and Dept.

For the CID, the CDate is in ASC order and if Dept=C and the next row is Dept=C...and next row is also...

Sorry, this is the last requirement.

The values are passed to the query from a drop-down list from SSRS report.

Both drop down lists are sames values:

1Months

2Months

.

.

12Months

1Years

2Years

3Years

.

100Years

BeginAge: 2Months EndAge: 48Years

But I have different scenarios to get the persons retrieved based on the parameters for BEGIN AGE and END AGE in WHERE Clause:

Like :

SELECT person, dob,

case when DATEDIFF(MONTH,dob,@SDate)/12>0 then...

Yes..This is an additional requirement. I need to retrieve the Persons based on the AGE range BETWEEN months and years.

But I also need to get the persons [WHERE age BETWEEN '4 Mths' AND '12 Yrs'/code]

Thank you!!

But I also need to get the persons WHERE age BETWEEN '4 Mths' AND '12 Yrs'.

Thank You!...

I found the below link but I cant pass the parameters.

http://www.codeproject.com/Articles/14085/Data-Driven-Subscriptions-in-SQL-RS-2000-Standard