Using John's good test setup... this is 1 place where a triangular join may work well because the groups indicated by Col1 are so small...

DECLARE @Table TABLE (RowID int IDENTITY(1,1),...

BTW... couldn't help but notice you're using @@IDENTITY... if a trigger is present, that could mess things up because @@IDENTITY returns the last id of ANY table updated.  Recommend you...

You bet, Adam.  Thanks for posting back.

And... they're exercising!  It's OK!  Let 'em go...   Articles are supposed to spark conversation and your's certainly has.  Take the good with the...

Your point was spot on, Andy... I'm just spinning it the other way...

Step back and look at what you're doing... is getting...

The formulas that both James and I wrote will automatically take care of that...

SET DATEFORMAT dmy

DECLARE @CurrentDate DATETIME

    SET @CurrentDate = '27-02-2004' --Leap year

 SELECT...

I guess I don't understand why anyone would apply foreign keys to such disposable data   Should be the other way around...

You wouldn't actually change the format of the column... just what the results of a SELECT on the column look like... (using GETDATE() in place of a column here)...

SELECT REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(26),GETDATE(),120),'-',''),'...

If the C:\User directory is on a machine other than the server, you must use the UNC format for the directory name... for example...

\\machinename\sharename\endentities.sql

... where "sharename" might be...

By the way... not my job to say so but I like the format of your code... nice and easy easy to read even when not in Courier

Heh... oh what a smile your brought to this ol' man's face this morning!  Thanks for the laugh, James!

Still waiting here on Earth... why would you want to swap data between two obviously disparate tables?

I don't know what you mean by "Depending if is bissextile year or not", but here's an example of the formulas you could use... replace @CurrentDate with GETDATE() and it...

Crud... more spam, Rog.  Will you cut it out, please?  Do an article or get someone to review your product... and, it's not going to be me 'cause I don't...