i already posted.i am trying to solve this from so many hours.

anybody here ssrs expert??????????

thanks guys,got the answer,

nope.if i remove this line,it works fine

they both are nvarchar

thanks got answer

my select statement

insert into #temp7

select a.shortname , a.portfoliobaseid , a.account ,a.InceptionDate,

a.DTDTWR,

MTDTWR = case when (a.MTDTWR is null) then

(exp(sum(LOG(CASE WHEN b.monthirr = 0.0 THEN 1 WHEN b.monthirr IS NULL THEN...

got it

thanks

HERE ISMY CODE

declare @Portfolio nvarchar(32)

declare @mtd float

DECLARE @qtd float

declare @Portfoliobaseid int

...

I AM ALREADY PUTTING IT INSIDE CURSOR BUT ITS REPEATING AGAIN AND AGAIN

ok.

but i like something like this,for each row return by query the loop should run.while there is row in the table

that is the condition i need ,i dont know what...

ok.this is simple question but nee dhelp.

i need something like untill there is value the loop should go.

i cant give any condition

suppose files

item1

...

thanks grant.i will start another thread,but this should work as well.

thanks a lot

i didnt get solution yet.

kindly help me

i want insert

insert into #temp3

select I1,account,id from account(p1)

union

select I1 from #temp2

i cant do this coz of union,what are other ways of i can...

can i do something like this

create table #temp4(account INT,

monthirr FLOAT)

it gives syntax error

INSERT INTO #temp4

(select account ,(select i1 from account(p1) phd

union

select MTD from #temp2) as...