Viewing 7 posts - 61 through 68 (of 68 total)
adam spencer (3/22/2011)
here is what I have
where DOS =
CASE 2011
WHEN AD.DM_ConfirmationID = 2 --Agreed
THEN year(isnull(AE.AE_PatientEncounterDate, AD.AD_Date))= 2011
WHEN AD.DM_ConfirmationID...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 24, 2011 at 10:30 am
Steve, this sounds like a great idea! There is a languish/anticipatory switch. Ofcourse if it's not in the budget, then maybe we could get the just the last...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2010 at 8:31 am
I feel your pain, it's so hard to upgrade. Well depending on your version you might have ticker tape, foil, or even a card deck.
Failing all that,...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2010 at 8:15 am
8" SINGLE - SIDED FLOPPIES - NOW THERE'S A TIMEWARP hehe:
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2010 at 7:56 am
I don't get the same hour, but the same date, minute, and seconds
The hour could not match since my local time is not GMT, (GMT+8).
My results:
2009-11-16 09:02:17.020 Monday
2009-11-16 09:02:17.020 Monday
2009-11-16...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 17, 2009 at 10:04 am
Ths link is wrong - should be http://www.ssmstoolSpack.com (tools is plural) - otherwise you go to bogus page
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 3, 2009 at 8:57 am
Hi Steve,
I feel your pain. You offer some great advice, your counsel of 'don't panic, and make a plan' is probably the most useful. No point of compounding the problem. But...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 16, 2006 at 11:11 am
Viewing 7 posts - 61 through 68 (of 68 total)