Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,473 total)

  • RE: Table Update Help Needed

    Wow. The new article is like 3x as long as the last one. Good stuff.

    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]

    November 27, 2009 at 12:26 pm

    #1085006

  • RE: Table Update Help Needed

    Jeff Moden (11/27/2009)

    Actually, the rewrite is out there now...

    My fault, I checked it again before I posted that, but I didn't fully read it, I just saw that it was...

    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]

    November 27, 2009 at 12:15 pm

    #1085003

  • RE: Table Update Help Needed

    TheSQLGuru (11/27/2009)

    Just asking is all, since there are quite a few of them and you are (to me) a new entity here. 🙂 I do seem to recall most...

    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]

    November 27, 2009 at 10:43 am

    #1084988

  • RE: Qty values for each day

    sarvesh singh-457805 (11/27/2009)

    I haven't got a calendar table. Is it possible to do this without creating the tally table.

    You can make non-permanent number tables using CTE's. Here's one example...

    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]

    November 27, 2009 at 9:48 am

    #1084970

  • RE: Table Update Help Needed

    Seth, did your update meet all of the requirements of the quirky update?

    Yessir. Why, does one seem missing to you?

    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]

    November 27, 2009 at 9:44 am

    #1084968

  • RE: Query question...

    I think you may have adequately conveyed the gist of what you want to do, however, it'd be easier for many of us to understand if you would work up...

    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]

    November 26, 2009 at 10:45 am

    #1084665

  • RE: sum() change result

    Getting closer. Did you read the article I mentioned?

    Put the data/table structure in a format I can do something with and include the where clauses for both...

    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]

    November 26, 2009 at 10:31 am

    #1084662

  • RE: sum() change result

    I don't understand the question. Please see the post in my signature on how to provide sample data to get a better idea of how to ask a question...

    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]

    November 26, 2009 at 9:34 am

    #1084642

  • RE: Alternative to cursors

    Yes.

    (And if you want a better answer, ask a more specific question.)

    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]

    November 25, 2009 at 11:25 pm

    #1084457

  • RE: Table Update Help Needed

    Heh, thanks. You know me, I'm always ready to jump on any chance to use that quirky update! 😉

    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]

    November 25, 2009 at 11:05 pm

    #1084454

  • RE: Averages from logon data

    jb-1079038 (11/25/2009)

    Hi Folks,

    I've introcuded a new environment variable to my clients, lets call it %LOGONTIME% with a value that changes and appends each time a user logs 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]

    November 25, 2009 at 8:10 pm

    #1084417

  • RE: Reclaiming unused space in a table

    Does a fill factor of 80 really explain that discrepancy though? The way I understood it, that should fill the pages 80% full, leaving unused space equal to 25%...

    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]

    November 25, 2009 at 3:17 pm

    #1084386

  • RE: need better way than row_number()

    You're missing the else's in the case statements that point to the rownumbers in the left joins. You can actually copy/paste/run that in SSMS to see what it does(although...

    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]

    November 25, 2009 at 3:12 pm

    #1084384

  • RE: need better way than row_number()

    Create a clustered index on (model, date1) ?

    That alone would likely have a massive performance impact.

    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]

    November 25, 2009 at 2:36 pm

    #1084363

  • RE: Table Update Help Needed

    [fEDIT] Irrelevant after I edited the code.

    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]

    November 25, 2009 at 11:00 am

    #1084226

Viewing 15 posts - 376 through 390 (of 1,473 total)