Viewing 15 posts - 451 through 465 (of 2,443 total)
I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it seems staging tables and updates in...
November 3, 2011 at 12:56 pm
SQLRNNR (10/31/2011)
L' Eomot Inversé (10/31/2011)
Thomw (10/31/2011)
Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL
Rather than...
October 31, 2011 at 1:42 pm
what do you guys use for calendar apps? (non-iPhoney people) <--hey, that's funny, didn't even mean that...
missed a couple user group meetings I meant to get to (online), would be...
October 26, 2011 at 8:03 pm
Fal (10/26/2011)
WayneS (10/26/2011)
And that's my point... SQL 2012 made the code so easy, a trained monkey could have done it. Compare the simplicity of the 2012 code to the other...
October 26, 2011 at 8:02 pm
Greg Edwards-268690 (10/26/2011)
Roy Ernest (10/26/2011)
SQLRNNR (10/26/2011)
Lynn Pettis (10/26/2011)
Okay, I'm sorry but that was just gross.Happy Halloween :-D:-D
So that is how a brain looks like? I thought is was just some...
October 26, 2011 at 2:36 pm
Droid Incredible 2, love it, use it for school too. And Stefan, interesting that because of that I'm "mostly [a] woman", I mean I had my suspicions, but had no...
October 26, 2011 at 12:13 pm
not sure how that 'work your phone through your pants' thing would really work. I can see volume or answer/hang up maybe, but they mention texting? Really? because that wouldn't...
October 20, 2011 at 2:43 pm
Steve Jones - SSC Editor (10/19/2011)
Nooooooooooooooooooooooooooooooooooo more pantsEspecially as it is not becoming too cold in CO to wear anything else in the am.
are you wearing the kilt at home...
October 19, 2011 at 8:04 pm
jared-709193 (10/17/2011)
October 17, 2011 at 10:26 am
I only wanted to talk to you anyway 😛
Thought we were *looking* for it to generate errors, so we know which procedures have syntax issues? Anyway, found a different post...
October 17, 2011 at 10:00 am
SET NOEXEC ON doesn't work for me on Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation ...
October 17, 2011 at 9:39 am
onecaring (10/13/2011)
October 13, 2011 at 7:51 am
SQLRNNR (10/12/2011)
Jack Corbett (10/12/2011)
SQLRNNR (10/12/2011)
Ninja's_RGR'us (10/12/2011)
Roy Ernest (10/12/2011)
October 12, 2011 at 3:14 pm
onecaring (10/12/2011)
Just use this function and get the exact age in "YYYMMDD" format (YearsMonthsDays)
average days in a year: 365.2425
average days ion a month: 30.436875
USAGE: SELECT dbo.udf_CalcAge('1960-01-01', '2011-10-12')
RESULT: "0510911" -- 51...
October 12, 2011 at 10:44 am
Similar question to dheeraj.marwaha, although not the same. Had to do this recently for a process that changed, and after building it using lookups and running into trouble because it...
October 12, 2011 at 7:27 am
Viewing 15 posts - 451 through 465 (of 2,443 total)