Pipe

You're welcome, I'm glad I could help.

Misdirection

Could you not do that as part of your insert statement? It's a bit of a chicken and egg situation otherwise.

There's probably quite a few ways of doing this but to give a useful answer we'll need some sample data please. How are you creating and populating the tables?

Thanks Lowell, it turns out it wouldn't have mattered if I'd set it to 64bit, 32bit,16bit,8bit or any other conceivable number of bits, I still wouldn't have been able to...

Reported as spam

Pick me up

mw112009 (3/9/2015)

Select top 100 * from tab1 order by col1 ---gives me the top 100 order by col1

Select top 200 * from tab1 order by col1...

Dammit! Didn't see select three!!!!!

Chicken

Wine

Poet

Parliament

Bank