Hi here is the example:

DROP Table #a

DROp Table #b

Create table #a

(

Col1 int

,COL2 varchar(10)

)

Create table #b

(

col1 int

,COL2 varchar(10)

)

insert into #a

Values (1,'Y')

insert into #a

Values (2,'N')

insert into #a

Values (3,'Y')

insert into #a

Values (4,'N')

insert into...

I did something like this below:

DECLARE @COPYDATE datetime

,@COPYDATE_END_OF_CURR_MONTH varchar(50)

,@COPYDATE_END_OF_1_MONTH_AGO varchar(50)

,@COPYDATE_END_OF_2_MONTH_AGO varchar(50)

,@COPYDATE_END_OF_3_MONTH_AGO varchar(50)

,@TODAY DATETIME

SET @COPYDATE = '10/31/2012'

SET @COPYDATE_END_OF_CURR_MONTH =convert(varchar(50),DATEADD(DAY,-1,DATEADD(MM, DATEDIFF(M,0,@COPYDATE)+1,0)),110)

SET @COPYDATE_END_OF_1_MONTH_AGO = convert(varchar(50),DATEADD(DAY,-1,DATEADD(MM,...

Is there any other way ...other tahn going with script task???

Thanks for the help.It worked.

Ignore....above message it found out the error !!! I added something in the code and saved it ..and forgot to remove.My bad.

Anyways thank you for your help.

Solved the issue.

Thanks.GOt it.

So, I tried Executing your way.

EXEC [dbo].[usp_Get_Investor] @InvestorCode_FROM=10100 ,@InvestorCode_TO=12600

But there are few values. But returns nothing.

Just displays: Command(s) completed successfully. 🙁

Oh yaa.Realized the mistake.... I corrected it.It worked.Thanks.

But when I tried to run the Sp by passing @InvestorCode_FROM and @InvestorCode_TO and not giving @Investor_all.

Example

EXEC [dbo].[usp_Get_Investor] 1000 ,2000

It throws error...

Thank you this should help me!!!

Thank you .I filtered the title like isnumeric(title)=1

I dont want to insert such columns.Please advice.

Issue is there is Aid with both "runquote" and "generatedocument" , need to load Aid with "Runquote",

and then load the Aid's which are not "runquote" but with "Generatedocumnet"

example: AID :...

tHANK YOU

requirement is that when they select the dates out of range and team should be blank and when ran should show "No records"

and my parameters are cascading.

No one replied.So, want to ask if we can "Pass blank parameter " and run report???

thank you!! More example are appreciated.