select distinct rl.Id,

rl.AlarmId, rl.Name

...

i need up date records in a batch,not just bulk insert

can anybody give me script for example i have 1256789 records and i need to update 5000 at a time

then...

thanks everybody

thanks

hey mark thanks,

i got solved,i need to create group and then in group properties ->sorting

thanks lynn,

it works now

thanks everyone

ok.it will solve my prob,but what about if i need to make 2 column static , hard coded and others are dynamic.it is possible?

i remove overlap ,but still getting space.

any other reason

i remove overlap ,but still getting space.

any other reason

additional question ,regarding spaces in report.

in my report i have 1 tablix ,above it i have textbox,in which i have tablix title.

now in design ,there is no gap between title...

ok.

i got solution ,the way ssrs works is it doesnt count 0 ,so in ssrs textbox expression ,i need to put something like this

DATEADD("d",-1,DATEADD("yyyy",DATEDIFF("yyyy","1/1/1900",Fields!T.Value),"1/1/1900"))

instead of 0 , i need to...

hi

i havent add two textbox,just add value of the filed to get total , =sum(field1.value + field2.value)

thanks .got solve it

thanks,got solved