Yes... but it it will be out of scope in the proc that has the exec statement... heh... please don't ask why 😉

So far as the cost of a DBA goes, I think the reason why Oracle DBA's get paid more is because of perception. I think many managers are under...

Leo Peysakhovich (3/9/2008)

---

noeld (3/19/2007)

---

A 10GB data warehouse is small enough to follow the proposed procedure.

When your data warehouse reaches 200 to 500GB you will get into a TOTALLY different...

Yep... Antonio writes good stuff. Still, I'd like to know why you need this type of "sort", please.

Ok... once you learn how to use a Cursor, THEN avoid them as if they were Leprosy 😉 There is very very little you actually need a cursor for...

Sorry... I know squat about DTS... not sure if activex will help here or not.

Can't be done... it's all or nothing.

It appears that all the variable declarations and presets are missing from the code... could you include those, Johan?

And, Andras' method will allow an index to be used if there is one. The conversions to VarBinary will not.

kgunnarsson (3/10/2008)

---

ok.. but that kind of defeats the propose where you want to work with the current row in the select part insert statement.

That is for each line in...

Oh yeah... the tabs are being correctly stored... they never show up correctly in a grid mode... if you want to verify they are there, look at the data in...

Since you're going from SQL Server TO SQL Server, you can solve the tab problem by using the "Native" format for both the export and the import. It's also...

Yeah... ever hear of the "DataBase Owner" role?

It's gonna be a mess if you have, say, 1000 employees... you said you have to do this "for some reason"... what is the reason?

What are you using to do the export with? DTS?