thanks,got solved

i want last day pf previous year,formula i correct ,its working in sql,

but i want to put same in ssrs expression

hi,

select dateadd(yy,datediff(yy,-1,@date),-1) is giving me last day of current year.

i want last day of previous month.

anyways got the answer

thanks,it worked in sql.

but nit in ssrs expression.

any idea?

thanks

i didnt get you,can you give me example how can i apply filter

thx

thanks

opc.three.i dotn except any answer from you.so dont bother even to see my thread

thanks dev.

i am working on it.will provide you sufficient information.

i got it,but anyhow i have to use while loop for condition

i remove cursor with while ,not improving still.

what other i need to use in place of cursor

ok.

i remove inserting in identity,but still nt improving performance

ok.i insert identity column.

but getting error

Msg 1077, Level 16, State 1, Procedure , Line 837

INSERT into an identity column not allowed on table variables.

Msg 8101, Level 16, State 1, Procedure,...

i tried join also.nothing seems to work.

my question is i have table variables,i can use

UNIQUE CLUSTERED ( id ,account)

in table definition. and its improving performance,but i need...