GilaMonster (11/11/2010)

WayneS (11/11/2010)

John Rowan (11/11/2010)

If you take the first week (1899-12-31 to 1900-01-05), all of these will evaluate to week zero....

Using the table that Craig posted (modified only to add a PK to it), here are two solutions. The first may be faster due to not having a sort operation...

Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other stuff...

Gail, the google link doesn't return anything for me.... 🙁

Carl,

Very interesting. The server I tested this on has only a default instance.

I wonder if this is connected to what Caine posted, where it is implied that SSMS is always...

Caine,

Thanks for this information. However, in looking in the registry for this information, it does vary based on the engine version. After 2000, there is an extra "Microsoft SQL Server"...

declare @s-2 varchar(100) = '1001,2001,1002,2002,1003,2003';

declare @id1 varchar(100);

declare @id2 varchar(100);

set @id1 = STUFF((SELECT ',' + Item

...

John,

Let's see if I can do it justice.

Formula: DATEADD(dd,DATEDIFF(dd,-7,DateOfPurchase)/7*7,-1))

select DATENAME(weekday, 0); -- = Monday

select DATENAME(weekday, -1); -- = Sunday

select DateAdd(day, -7, 0); -- = 18991225

So, take the number of days...

You could use the sp_OA procedures, with "Scripting.FileSystemObject", to create files.

Chris Morris-439714 (11/11/2010)

I had the same thought a couple of weeks ago, but a quick look revealed he'd been quite active, though not...

Yeah, I also wish so ...

Carl Federl (11/11/2010)

"In the case of backups, this allows you to specify a backup with just a file name (from T-SQL), and the backup will go to this...

Sally,

Two things that I've noticed in looking over this:

1. The order that you evaluate things is important. Looking for "U.S." before "U.S.N." will always find the match on U.S., and...