i want to do in ssrs report only

i have two dataset from two different database servers

How to compare bewteen datasets in ssrs

hi

i am thinking other then replace which can be to improve queery performance

thanks,

pradeep

Hi

i have table called t1

with column name offers with data as

"entitlementwrapper" : [ {

"Type" : "Factory Warranty",

"Date_Type"...

hi

i need out put as

type ...

in my database i have 53 tables

in every table it as created date as column

i want a query to find all tables data count on particular date...

i have 53 tables with createddate column

in need to find count of all tables by passing created date as paramater

thanks,

Pradeep

with out joins can i use temp tables whether it will improve performance or not

with joins can i use temp tables can it improve the performance

i am unable to start the service it is giving error

Now table as no data in feature table may get 1 million record per day for that case if i change decimal(18,0) to int is that improves the performance...

Decimal 9 bytes int 5 bytes it may reduce the size for that case i am thinking of it

if many dft is that affect the performance are not

in SSIS Package can i get data from muitiple table in single data flow task

and can we pass connection string and tables name

thanks