hi Dhananjay

if those 3 SP's have the same signature in the form of columns then why not combin those 3 SP's into 1 SP or create a 4th SP...

Also check in the SSRs config file.

Probably the localhost name is used there in stead of teh hostname.

Normally you can alter this config file with the GUI from configuration manager,...

I agree with steve,

SSIS would be your best bet if you have the knowledge to use it.

Alternative if you don't have SSIS knowledge you can use a SP on the...

As the OP marked, with a whole lot of changes happening...

Using stored procedures has also the following benefits.

Security : dba can determine who can execute what

Tuning : mostly stored procedures are written by sql developpers who mostly know to find...

I don't think i really understand your question here.

But for what i think you mean, the best way to go would be to change the tablestructure of table 1 with...

hi Mvs2k11,

I don't think there is any generic query available for what you want to do.

Besides there are duplicate studentnames in the different tables.

My best guess would be to create...

Tnx Guys,

This Round (Truncate) was just what i needed today 😉

Wkr,

Eddy

shelts (9/28/2012)

---

Yes I know that but for each new report the date format reverts back to US with the month first. The easiest way around it I've found so...

Guess it depends

Mostly on the programming background you have

In C languages it would be !=

Whereas in Visual Basic languages it would be <>

I myself , i mostly write in Visual...

Nevermind,

I found the article,

http://www.sqlservercentral.com/Forums/Topic436388-145-1.aspx

Wkr,

Eddy

yeah but thats just whats make my wonder..

if a defrag tool defragmenst my mdf file from lets say 10 pieces, back to 1 piece

then i wonder, how that affects the...

What would be the best way for defragging a disk on witch database files are also stored.

backup database

defrag disk

and then restore database

that is what i think would be the...

why would you go into reading line per line and insert that into the dataview.?

put the result of your sqlstatement into a dataset

dim myds as dataset = new dataset("sqlstmt","sqlconenction")

then assign...

Hi steve,

I think i understand what you mean..,

Tomorrow morning, first thing i do when i get at work (here its now 7PM)

is trying what you suggested..

Keep you updated,

Wkr,

Eddy