|
You can always write a CLR stored procedure and return SqlDateTime.MaxValue from it. 
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
We don't do CLR stuff in our database if we can avoid it.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
This guy wrote some code to find it: Max Date Value[^]
Quote: This took 7 seconds to run on my machine, fyi.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
#realJSOP wrote: you have to know what it is before you can use it.
If only it was documented somewhere[^]! 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
That's not the point.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Why "something like" this:
DECLARE @@SqlDateTimeMaxValue DATETIME = '9999-12-31 23:59:59.997'
When such a form has never been an issue. Unless what you meant to say was this:
DECLARE @@SqlDateTimeMaxValue DATETIME
SET @@SqlDateTimeMaxValue = '9999-12-31 23:59:59.997'
Which is perfectly acceptable ("Command(s) completed successfully.")
|
|
|
|
|
Assigning a value to a variable when you declare it has been perfectly valid since SQL 2008. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yes, thank-you Richard ...
John's a very busy man these days. What with the ... annoyances and all.
|
|
|
|
|
0) SQL Server has no server-wide variable for the max possible datetime.
1) SQL server does not support adding custom server-wide variables (such as @@ROWCOUNT), so I can't add one myself.
2) I was trying to avoid doing exactly what you posted. I f*ckin know I can, I was just trying to avoid doing that in EVERY stored proc that needs it.
Are we all clear now?
|
|
|
|
|
Hi All,
Odd to see the newest message is getting for 8 hours old, I wonder if there is an issue?
Glenn
|
|
|
|
|
Nope, the newest thread may be that old but not the message. 
|
|
|
|
|
Thank you for contacting The Lounge, your post is important to us.
Please hold and a member will deal with you when one becomes available.
In the meantime, please listen to the hold music[^].
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thank you for contacting The Lounge, your post is important to us.
I'm sorry that you have been waiting, we are having a busy period and will be with you as soon as possible. Please hold and a member will deal with you when one becomes available.
In the meantime, please listen to the hold music[^].
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thank you for contacting The Lounge, your post is important to us.
I'm sorry that you are still waiting, we are having a busy period and will be with you as soon as possible. Please hold and a member will deal with you when one becomes available. You currently are number 5833582 in the queue.
In the meantime, please listen to the hold music[^].
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thank you for contacting The Lounge, your post is important to us.
I'm sorry that you are still waiting, we are having a busy period and will be with you as soon as possible. Please hold and a member will deal with you when one becomes available. You currently are still number 5833582 in the queue.
In the meantime, please listen to the hold music[^].
Alternatively, you could use our electronic system if you know which department you need:
To continue in jargon, press 1. J os haluat jatkaa suomeksi, ole hyva ja paina 2.
Please listen closely to the following menus, as our options have changed. For technical support, press 1. For financial support, press 2. For support of the fleshy parts that jiggle during exercise, press 3. For emotional support, please hang up and call 888 HOT-LIVE.
Please note that we are currently experiencing temporary, localized service interruptions in Nome, Alaska *; Phoenix, Ariz.; Tijuana, Mexico; and all of North America east of the Rocky Mountains. If you live in one of these regions, please hang up and do not call back until we tell you. We appreciate your patience while our technicians ignore the problem.
If your appliance is less than 1 year old, press 1. If you are unmarried or are not sure, press 2.
In order to serve you better, it will be helpful for us to know which order you belong to. For Primates, press 1. For Cetacea and Proboscidea, press 2. For Jesuit or Dominican, press 3. For Knights Templar or Hospitaler, Knights of Pythias or Columbus, as well as Masons, Elks, and Kiwanis, or if you are unsure, press 4. If you are a Franciscan and have a rotary phone, please stay on the line.
Please key in the model and serial number of the product you are calling about. The model number is the series of 12 letters and digits that is visible when you push the unit away from the wall, work your head into the gap using a crowbar and No. 10 machine oil, and train a beam of ultraviolet light on the lower three centimeters of the right-hand rear surface of the appliance. If the model number is obscured by dust or cockroach detritus, wipe it with a soft, lint-free cloth soaked in a solution of ordinary rubbing alcohol, Kirschwasser, and formaldehyde. The serial number is the 37-digit number inscribed by means of laser nanotechnology on the underside of the unit and is not visible to the naked eye. When you have entered both numbers, press the pound key.
Note that at any point you may return to the previous menu by hanging up, calling again, and repeating the process until you reach the point just before the point you are at right now.
Please listen carefully to the following choices and select the one that best describes the problem you are calling about: If water is condensing on inner surfaces or leaking from under the door, press 1. If you are having trouble sending or receiving e-mail, press 2. If you are experiencing sharp, shooting pains in the left shoulder or a feeling of constriction in the chest, press 3. If you have lost your faith in a Supreme Being or any intelligible order in the universe and feel a desperate need for human contact, press 4. If you smell gas, press 5. To repeat this menu, press 6. To return to the previous menu or to a state of infantile bliss, press 7.
Please note that while you were listening to the previous menu, our options changed yet again. For Option 1, press 4. For Option 7, press 3. For Option 6, press 7. For Options 2 through 4, press 0 or hang up and call our Consumer Relations Department at (427) 555-9221. Long-distance charges may apply.
Most common problems can be resolved at home by following a simple sequence of diagnostic tests and procedures. We will now guide you through such a sequence. If you wish to skip this section, press 1, 3, and 9 simultaneously while restarting your telephone. Please note: If, while answering these questions, you see smoke or flames or if your chest is warm to the touch, hang up and call 911.
Stolen from Slate.com[^]
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thank you. I needed a good laugh this morning.
_______________________________________________________________
Ah don't lean on me man, cause you can't afford the ticket
|
|
|
|
|
I was about to ask if you were really bored or had that saved somewhere, then I got to the end.
|
|
|
|
|
I nominate the hamster dance song as CP's Official Hold Music (aka OHM )!
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
|
Nah: In the air tonight[^] - but for that "authentic hold music" feel, at 2:53 precisely it should cut to an insincere announcement that they are sorry it's taken so long - and the track resumes at 4:19.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Great! Now I am going to have to listen to the Pink Floyd album...
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
A REST API was implemented 
|
|
|
|
|
Never done with banalities (10)
|
|
|
|
|
That's a good one!
If it isn't solved in a couple of hours - and I'm sure it will be - I'll take it. 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks - it's getting late over here... 
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
