Thanks Pravin... I always appreciate the feedback.

Just for grins, here's the CTE version without TOP...

;WITH

cteTally AS

(

SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS N

FROM Master.sys.SysColumns

)

SELECT DATEADD(dd,(t.n)*14,'20090102') AS BiFriday

FROM cteTally...

For anyone that reads this that may still be using SQL Server 2000, the system table called spt_Values that Madhivanan used has a bunch of different things in it depending...

I'm still looking forward to the sky writing...

Heh... everyone gets all bent out of shape when someone uses a cursor in a place where it shouldn't be, but no one says boo when someone uses a cursor...

Thanks for the backup Lowell... I was thinking that I need to include a graphic and a better explanation... you saved me some work. Thanks, ol' friend.

Not the login you're using... the login the SQL SERVER is using when it starts up on the network...

There are some things I look for in security... are things like SSN's, Pins, Passwords, Account numbers, or even the "last 4 of the SSN" encrypted? Who has access...

Absolutely... it does help folks understand if they know you know it's a very...

Heh... Now, now, David... it's set up perfectly for an SQL Injection attack... what are you crabbin' about? 😛

Matt Whitfield (12/26/2008)

---

Fair enough. I re-read...

bitbucket (12/26/2008)

---

Hey can I get a pay raise each time I write some T-SQL that uses cursors and triangular joins and takes forever to run, tying up the server so...

The server you are working on, whether local or remote, must be logged in as a user that can "see" the spreadsheet using a UNC instead of a mapped drive.

Just bought a nice new Calypso Cruiser (bicycle)... 7 speeds... nice super heavy duty...

:blush: That's awfully nice...