Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,473 total)

  • RE: Merging duplicate rows

    Maybe I'm missing something... but I don't see where that script generates that output.

    The problem with displaying that data on one line is your Y/N on Ind3. You need...

    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 4, 2008 at 1:26 pm

    #893866

  • RE: compressing / collapsing numbers

    GROUP 1!

    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 4, 2008 at 1:22 pm

    #893861

  • RE: decode pl/sql

    The base idea here is to boil this query down to its base elements and figure out everything that's causing issues. At this point, you'd start commenting out joins...

    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 4, 2008 at 10:16 am

    #893747

  • RE: decode pl/sql

    I can't see how that code would give you that error. This works fine:

    DECLARE @b-2 nvarchar(50)

    SET @b-2 = 'afeakfe;a-086'

    SELECT CASE WHEN CAST(RIGHT(@b,3) as varchar(3)) = '086' THEN 1 ELSE...

    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 4, 2008 at 10:00 am

    #893729

  • RE: decode pl/sql

    I knew something didn't look right with that STR function this whole time. I kept looking at it and ignoring it, then looking at it and ignoring it. ...

    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 4, 2008 at 9:48 am

    #893719

  • RE: decode pl/sql

    Ok, starting all the way at square 1. This *should* run.

    If it does run, begin by uncommenting (removing the --'s) from the where criteria one line at a time....

    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 4, 2008 at 9:34 am

    #893708

  • RE: decode pl/sql

    Ok, continuing to try to isolate the error... try this one:

    SELECT TOP 100

    CASE

    WHEN orig.orig_system is...

    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 4, 2008 at 8:57 am

    #893683

  • RE: decode pl/sql

    paul.starr (11/4/2008)

    error is still

    Msg 8114, Level 16, State 5, Line 1

    Error converting data type nvarchar to float.

    After running mine?

    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 4, 2008 at 8:51 am

    #893678

  • RE: SQL Server 2008 Intellisense! Love it or hate it?

    Now that I'm getting used to it (and occasionally begrudgingly adding my from clause before my select) it's working a little better. It's still pretty sluggish and occasionally annoying...

    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 4, 2008 at 8:39 am

    #893670

  • RE: Help with update statement

    Please refer to the article in my signature for the proper way to post table DDL and sample data. Doing so will get you better, quicker answers.

    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 4, 2008 at 5:36 am

    #893552

  • RE: Please need help on looping through the dataset!!!

    Jeff Moden (11/3/2008)

    It's amazing, even to me, how often that particular solution has been used, lately. Nice job, Seth. 🙂

    When I read (and then later fully comprehended) the way...

    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 3, 2008 at 6:26 pm

    #893360

  • RE: compressing / collapsing numbers

    Jeff Moden (11/3/2008)

    Only thing you might want to try, just to be empirically correct, is start out with GROUP = 0...

    Have you ever actually talked to a Group 1?...

    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 3, 2008 at 5:53 pm

    #893349

  • RE: decode pl/sql

    Does this run? (I converted your query to use current JOIN syntax... hopefully I didn't mess it up. If I did, replace the FROM and WHERE with your...

    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 3, 2008 at 4:22 pm

    #893331

  • RE: compressing / collapsing numbers

    Greg Snidow (11/3/2008)

    Garadin (11/3/2008)

    Trying... to... resist...

    Gah.

    Seth, I was rolling laughing at that. I'm a huge Dilbert fan, so any time I see 'Gah', it elicits strong images of Dilbert...

    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 3, 2008 at 2:33 pm

    #893276

  • RE: compressing / collapsing numbers

    Trying... to... resist...

    Gah.

    Jeff Moden explains this technique in his article located here:

    http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    If you don't read that article, make note of several things.

    1. I added a clustered index...

    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 3, 2008 at 2:11 pm

    #893266

Viewing 15 posts - 1,171 through 1,185 (of 1,473 total)