I like the solution using derived tabels but thanks to everyone who replied!

Barkingdog

Thanks for the replies. I'll need to digest them a bit.

BTW can any think of a solution not using a CTE?

Barkingdog

Thaks for the interesting reply but when I ran your (CTE?) I got

1jack15.00

4Fred35.00

The first row is exactly what I want but the second row is not. I expected 17 (which...

The idea was to always have the primary key sequence like this : 1,2,3,4.... (a psychological, not computer, issue.)

WELL, after reading the replies to the question I have scrapped the...

>>>is your SAN able to grow the LUNS on the fly without negatively impacting Windows?

I don't know the answer and didn't even think of the question (i.e. "on-the-fly" or...

I found this tidbit too:

>>

Yep, you're absolutely correct. This is an issue with Windows 2003 and prior versions for every SAN out there. 2008 handles it by automatically...

>>>Don't forget to use diskpart.exe to align the disk partitions (align=64)and don't format the drives with the default (4k) blocksize

I don't know what "algn=64" refers to but I'll read up....

The backups themselves will go on the SAN (initially) on our low I/O drives. They will ultimately be saved to tape.

Barkingdog

Only C is an internal drive.

What would you recommend for a high speed OLTP data drive if not RAID 5? (RAID 0 + 1)?

Barkingdog

I'll keep my eyes "open" when using DISTINCT.

BD

Great answer. Thanks to everyone.

barkingdog

I think that will do it!

Barkingdog

Jeff,

A fantastic counter-perspective!

Thank you,

Barkingdog

Thank You Jeff.

Thank you everyone for your replies.

What a confusing bit of arcane stuff.

Barkingdog