Viewing 15 posts - 8,461 through 8,475 (of 26,490 total)
TravisDBA (3/15/2013)
March 15, 2013 at 12:23 pm
TravisDBA (3/15/2013)
Lynn Pettis (3/15/2013)
TravisDBA (3/15/2013)
March 15, 2013 at 11:57 am
TravisDBA (3/15/2013)
March 15, 2013 at 11:45 am
Okay, drop the religious debate. It will go where we really don't want it to go really fast.
March 15, 2013 at 11:29 am
Stefan Krzywicki (3/15/2013)
SQLRNNR (3/15/2013)
This thread is now at 39,153 posts. Do we start the countdown now to 40,000?Isn't 39,153 to 40,000 a count up?
Naw, wait until we are closer...
March 15, 2013 at 10:40 am
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
SQLRNNR (3/15/2013)
Jeff Moden (3/14/2013)
foxxo (3/14/2013)
Sign up to the petition to keep it:
https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader
I use it daily to keep track of several SQL blogs and it keeps RSS feeds...
March 15, 2013 at 10:38 am
SQLRNNR (3/15/2013)
Jeff Moden (3/14/2013)
foxxo (3/14/2013)
Sign up to the petition to keep it:
https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader
I use it daily to keep track of several SQL blogs and it keeps RSS feeds synchronised between my...
March 15, 2013 at 10:27 am
You may also want to read this: http://www.sqlservercentral.com/articles/T-SQL/67898/.
There have also been several other similar articles written recently on SSC, just do a search on deleting large number of rows.
March 15, 2013 at 7:46 am
By the way, you still haven't told us how you want to handle situations where one or both of the dates are null. If date1 is null and date2...
March 15, 2013 at 7:42 am
s.lakhanpal6776 (3/15/2013)
your simple way of doing this is :-select cast(month(GETDATE()) as varchar(2))+'/'+cast(day(GETDATE()) as varchar(2))+'/'+cast(year(GETDATE()) as varchar(4))
Using CONVERT with correct format code is the simplest. This is a lot of...
March 15, 2013 at 2:31 am
sestell1 (3/14/2013)
Hugo Kornelis (3/14/2013)
Richard Warr (3/14/2013)
What do I have that is different (I'm in the UK if that helps)?
Locale settings.
Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are NOT a...
March 14, 2013 at 8:30 pm
Jeff Moden (3/14/2013)
allmhuran (3/14/2013)I'm not sure what happened to this forum, the level of courtesy and respect seems to have dropped off. Perhaps it has become too cliquey.
Nah... don't let...
March 14, 2013 at 7:53 pm
dhananjay.nagarkar (3/14/2013)
When you say-
"
I haven't seen all the other threads but from what you posted I can't figure out why you are using DATEDIFF at all. It doesn't meet...
March 14, 2013 at 7:30 pm
Sean Lange (3/14/2013)
March 14, 2013 at 3:01 pm
This is the fourth or fifth thread you have started for the same question. Creating new threads every day or so isn't going to get you more help. ...
March 14, 2013 at 2:54 pm
Viewing 15 posts - 8,461 through 8,475 (of 26,490 total)