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...

Mal D!

Glad to see your posts... thought I was the only wirehead with the idea of "Yes, perhaps its time to re-evaluate", but in the direction of maybe it's worth...

Thank you...

Thanks for the feedback, Rom.

Thanks.  It would be nice if you shared your solution with us... both the function and the cursor, please.