That was my first thought as well but the start date (which is generated by sql server)

is too close (sometimes identical) for it to be a double click by the...

Luke,thank you .

I'll check those out.

Luke, thanks for replying.

In short i'm looking for SQL2000 equivalent of the SQL2005 Pivot function

so for example if i have a header table Called manager

and line table called underlings (each...

I dont know if that's the best way to do it but i simply write my file to a directory and then use active x task to execute a batch...

Awesome, thanks!

Crap, when i started responding saying that it works ok i realized that it will not work in all cases after all. It'd work ok in a situation where i have a single...

Thanks to all who gave their input.

I will use the strange join statement i came up with. Unfortunately creating a stored procedure is not an option at this point.

Thanks again.

martin

Thanks for your help.

It works great in query analyser but... when i try to stick it into a lookup task on my dts package (which is what i need this...