Forum Replies Created

Viewing 15 posts - 181 through 195 (of 1,473 total)

  • RE: Creating Indices on Temp Tables from Stored Procedures

    CirquedeSQLeil (4/7/2010)

    TheSQLGuru (4/7/2010)

    Paul White NZ (4/7/2010)

    TheSQLGuru (4/7/2010)

    BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎

    Superb.

    And...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 10:24 pm

    #1148013

  • RE: creating table issue

    Steve Jones - Editor (4/7/2010)

    Rob Schripsema (4/7/2010)

    You mean, if I stick around here long enough, I could be in high demand for dates, parties and other social events, too? ...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 10:20 pm

    #1148012

  • RE: creating table issue

    Wait... Parties?

    WHY WAS I NOT TOLD OF THIS. I LOVE PARTIES. :crazy:

    Well, Ok. Actually I just love beer... but you know what you normally have at...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 8:52 pm

    #1147984

  • RE: Splitting Comma Delimited String into Columns

    See if this will work for you.

    http://phelabaum.com/archive/2010/02/tally-table-delimited-list-to-table/

    Edit: Sorry, just read that a bit closer, my function might be too hard to adapt.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 8:36 pm

    #1147980

  • RE: Installation error: Invalid namespace

    The last time I got an invalid namespace error was when I was trying to install a 32 bit app on a 64 bit machine. May not apply, but...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 8:31 pm

    #1147978

  • RE: mis-appying a cross apply table value function?

    RBarryYoung (4/7/2010)

    You probably need it to be an inline-TVF.

    That's what my thought was as well, at least to cover the difference in 4s vs. 690ms. I'd heard that they...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 8:28 pm

    #1147975

  • RE: mis-appying a cross apply table value function?

    Any chance you had the Actual Plan on when you were testing? I show the scalar as the fastest, but without the plan on none of them are that...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:53 pm

    #1147960

  • RE: Data compression

    Most of the backups I've seen have had somewhere between 50-80% size reduction. That's just ballpark possible numbers though, as Jeff said, it depends on the Data.

    The live data......

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:30 pm

    #1147956

  • RE: Date Manipulation with DATEADD/DATEDIFF

    Thanks.

    Nothing like actually having an article published that lets you see all the things that you forgot to add to it! :hehe:

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:25 pm

    #1147954

  • RE: Recursive cross join to get all available combinaisons

    This would make a great TSQL Challenge. I've been going around in circles for a couple hours now trying to figure out a way to do this in a...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:22 pm

    #1147953

  • RE: Incorrect syntax near the keyword 'IF'.

    You can also move the IF up a line to be before the insert statement. You'll need to add the insert again just below your else.

    IE:

    IF...

    insert...

    select...

    else...

    insert...

    select...

    That said, there's a...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 4:02 pm

    #1147835

  • RE: Blocks query does not give accurate process query

    This is probably not the reason, but I've never been able to find an answer as to *which* sql handle you really need to be grabbing. (There are often...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 3:53 pm

    #1147820

  • RE: Date Manipulation with DATEADD/DATEDIFF

    Elaine Shafer-401422 (4/7/2010)

    I frequently use SELECT CAST(FLOOR(CAST(<yourDateHere> AS FLOAT)) AS DATETIME)

    Interestingly, rounding happens near midnight. The following returns '2010-04-08 00:00:00.000':

    DECLARE @Date DATETIME = '2010-04-07 23:59:59.999'

    SELECT CAST(FLOOR(CAST(@Date AS...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 11:26 am

    #1147589

  • RE: Date Manipulation with DATEADD/DATEDIFF

    ArkWare (4/7/2010)

    Seth,

    very nice. good explaination.

    I have one question...

    in the following code, isn't it returning the first of the week +/- 2 days?

    SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2)

    --: 2010-03-01 00:00:00.000 Start of...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:56 am

    #1147342

  • RE: Date Manipulation with DATEADD/DATEDIFF

    ArkWare (4/7/2010)

    mbarkell (4/7/2010)

    On my system using the query for the first day of the week gives Monday instead of Sunday which is, of course, incorrect. Is this based on...

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

    April 7, 2010 at 7:51 am

    #1147340

Viewing 15 posts - 181 through 195 (of 1,473 total)