i am not getting any error msg,the query is executing indefinite time,

if i put insert into @temp7

without it i am getting data

i mean @temp7 ,its not getting into @temp7

this is not working,

i am calling another sp.

but its not getting into @temp table.

insert into @temp7

EXEC pPortfolioDashboard

@Portfolios = @AdjustPortfolio,

@FromDate = @FromDate,

@ToDate = @ToDate,

whats wrong,how to...

got clear now.

thanks,thats what i wanted to know

that was not code,i was just explaining you.

anyways so it will take + in portfolio after that

ALTER procedure[pPortfolioDashboard]

------Required parameter----------------

@SessionGuid nvarchar(48),

@FromDate datetime,

@consolidate bit,

---optional parameter-------------------

...

do i need to put any variable,how can i put just this statement

suppose i declare @boolean bit,

now case

it wont wokr

where i need to put this statement,in sp or in the report,if in the report where?

thanks Lynn.Got solve myself.

i needed to use table variable as it is stored in the memory.i was displaying my result with temp.

so ssrs was not picking it up

i gave you ddl of my temp table.

if i remove temp table ,and just keep select statement,i am not getting any error ,in dataset in report.

like

@Portfolios or @PortfolioObjectID cannot both...

create table ##temp1(shortname nvarchar(255),

portfoliobaseid int,

...

need a suggestion

i am putting my select statement in temp table.

if i remove this temp and only keep select ,i am not getting this error.

Is there any limitation of...

my question is particular sp.

i dont find option to put its name

i dont know ,if anybody knows,but my all previous sp has same thing that i am doing.

and its working fine

i posted in ssrs thread.

nobody is giving me reply