Viewing 15 posts - 8,131 through 8,145 (of 9,399 total)
That was an excellent question. While I was surprised to find the answer while doing the research, it is what it is...until MS changes it. 😀 Thanks for...
May 7, 2014 at 6:52 am
ChrisM@Work (5/7/2014)
The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret.
I think this is a very nice way to put it....
May 7, 2014 at 6:44 am
Stuart Davies (5/7/2014)
BWFC (5/7/2014)
Litterletter
Writing
May 7, 2014 at 6:04 am
SQLRNNR (5/6/2014)
Revenant (5/6/2014)
Ed Wagner (5/6/2014)
crookj (5/6/2014)
SQLRNNR (5/6/2014)
Stuart Davies (4/29/2014)
Zeus
dog
Day Afternoon
Beach
Boys
Beatles
Bug
May 6, 2014 at 12:20 pm
Lynn Pettis has a post with some very useful date functions that I think you'll like at http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/.
Specifically, I think you'll like these two:
select dateadd(yy, datediff(yy, 0, GETDATE()), 0) ...
May 6, 2014 at 7:27 am
crookj (5/6/2014)
SQLRNNR (5/6/2014)
Stuart Davies (4/29/2014)
Zeus
dog
Day Afternoon
Beach
May 6, 2014 at 7:01 am
I also found myself debating between the bit and the tiny integer. I know MSDN says that a bit is an exact numeric that supports a 0 or 1,...
May 6, 2014 at 6:51 am
I heard you when you said this is a learning and growth exercise and not for production code. It seems likely that whatever you come up with will form...
May 2, 2014 at 6:07 am
An easy one to end the week, so thanks. It's something I use every single day, so I actually had to re-read it looking for the trick.
May 2, 2014 at 5:53 am
TomThomson (5/1/2014)
Steve Jones - SSC Editor (5/1/2014)
Can someone do me a favor and try to edit a few of their own posts?got a report of a bug here: http://www.sqlservercentral.com/Forums/Topic1566649-433-1.aspx?Update=1
It's a...
May 1, 2014 at 1:31 pm
Test post
Test edit post
Test edit post again
May 1, 2014 at 1:23 pm
JAZZ Master (5/1/2014)
Ed Wagner (5/1/2014)
BWFC (5/1/2014)
Ed Wagner (4/30/2014)
Stuart Davies (4/30/2014)
BWFC (4/30/2014)
Heracles
Labour
Work
Workload
Overload
Time
Lord
Peace
May 1, 2014 at 7:03 am
BWFC (5/1/2014)
Ed Wagner (4/30/2014)
Stuart Davies (4/30/2014)
BWFC (4/30/2014)
Heracles
Labour
Work
Workload
Overload
Time
May 1, 2014 at 6:51 am
Stuart: You hit the nail on the head. I shouldn't have assumed that they were integers, but I did.
DonJunville: You'll be fine until you create a row that...
April 30, 2014 at 6:39 am
DonJunville (4/30/2014)
Stuart Davies (4/30/2014)
SELECT CONVERT(DECIMAL(4, 2), CAST(NULLIF(t.SLAHours, 0) - t.TotalDownTime AS REAL)
/ CAST(NULLIF(t.SLAHours, 0) AS REAL) * 100) AS...
April 30, 2014 at 6:05 am
Viewing 15 posts - 8,131 through 8,145 (of 9,399 total)