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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 19, 2011 at 8:04 pm
jared-709193 (10/17/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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 ...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 17, 2011 at 9:39 am
onecaring (10/13/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
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...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 12, 2011 at 7:27 am
Viewing 15 posts - 451 through 465 (of 2,443 total)