Neither. Do a 2 column join

select t.ItemNo, t.BatchNo, a.qty, b.qty, c.qty from

(select ItemNo, BatchNo from TableA union select ItemNo, BatchNo from TableB union select...

Anything in particular you're looking for on 2008?

dcorbitt (7/22/2008)

---

Stick it in a sproc so you don't have to look at it. No promises on the speed, but might be okay.

Another option would be a cursor with a...

Please ask your dba if it is acceptable for the stored proc to impersonate a sysadmin login.

.dat?

That's not a standard SQL file exention. Is it a backup? How did you ceate the .dat file?

Also, what have you tried and what have the results been?

Not sure about SQL 2000. Enterprise edition won't, standard edition won't. Personal edition should.

SQL 2005, only Developer and Express will install on XP Home and you need to be on...

Grant Fritchey (7/22/2008)

---

However, some tables statistics get out of date despite the automatic updates. So we update them manually, on most systems once a week or less, during off-hours, on...

Please give more info about what you're trying and what permission level various users have.

Is the owner of that proc a sysadmn? If not, that particular execute as is useless....

Be...

No. The max number of tables in a query n SQL 2005 is 256.

My I suggest you break the query down, create temp tables to store interim results then join...

What's wrong with the one Jack gave you in the other thead?

Please reply there. Multiple threads just waste people's time.

Sandy (7/22/2008)

---

if you believe it or not, I just changed the * to 'x' in select statements, its changed from index scan to index seek, i got surprised, why query...

No need to ask this again. There are already a number of answers to your older post.

Duplicate thread. No replies to this please. Direct replies to the older thread at:

http://www.sqlservercentral.com/Forums/FindPost537514.aspx

Why?

Hae you consided backing up to disk then copying the backup file across the network?