Viewing 15 posts - 55,501 through 55,515 (of 59,078 total)
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...
August 6, 2007 at 6:36 am
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...
August 6, 2007 at 6:19 am
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...
August 6, 2007 at 5:27 am
I guess I don't understand why anyone would apply foreign keys to such disposable data
Should be the other way around...
August 6, 2007 at 5:23 am
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),'-',''),'...
August 6, 2007 at 5:18 am
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...
August 6, 2007 at 5:10 am
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
August 6, 2007 at 4:57 am
Heh... oh what a smile your brought to this ol' man's face this morning! Thanks for the laugh, James!
August 6, 2007 at 4:55 am
Still waiting here on Earth... why would you want to swap data between two obviously disparate tables?
August 6, 2007 at 4:53 am
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...
August 6, 2007 at 4:30 am
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...
August 6, 2007 at 3:59 am
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...
August 6, 2007 at 3:53 am
Thanks. It would be nice if you shared your solution with us... both the function and the cursor, please. ![]()
August 5, 2007 at 1:57 pm
Viewing 15 posts - 55,501 through 55,515 (of 59,078 total)