thanks hopper.. i will check where exactly my team require this.

rs -i myfile.rss -s http://localhost/reportserver

-v datasource=Northwind

myfile.rss is a vb script file. sample file can be found on net. simple script contains details of the report/datasouce need...

hi vedran,

thank for you reply.

yes i am agree with-nolock read dirty rows but this is confirmed that there will be no transaction rollback.

so there is no harm in using no...

yes sir, will take do so!

yes, till now its relational database only! thanks :-)for your suggestion.

I know that temp tables are created in tempdb by default and automatically dropped on session close.

he was telling that there would be more logging, caching etc. in case...

thanks for your quick reply jeff.

Although i am already using temp tables, but my boss:):-D suggested me use physical table instead and like you i was also surprised.

Thank you GilaMonster, Eugene and Paul for your valuable inputs

@paul-2 : I will cheer for newzeland during next india-newzeland battle;-)

thank you paul

🙂

hi kingstom,dev

thank for u ur quick reply.

derived/nested query is ok. but we will have a performance issue with this.

i thought there would be some other way around if i want...

hi Gianluca,

here is an example

create table #TransactionTable

(

ClientCode varchar(50),

buyqty bigint,

sellqty bigint,

rate decimal

)

insert into #TransactionTable values('1001',20,30,10)

insert into #TransactionTable values('1001',10,30,8)

insert into #TransactionTable values('1001',80,30,9)

insert into #TransactionTable values('1002',2,30,20)

insert into #TransactionTable...