Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 1,473 total)

  • RE: Help needed: Recursive CTE to flatten text columns into comma delimted field

    Lynn Pettis (11/14/2008)

    This code handles the values provided by Seth.

    Oops, yeah it does. Ignore my earlier comments about the extra piece, I keep misreading STUFF.:blink:

    As a side note, the...

    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 14, 2008 at 10:41 am

    #898745

  • RE: Help needed: Recursive CTE to flatten text columns into comma delimted field

    Can your data include commas as well? Let's have a for instance:

    ID TXT

    1 This is my first line of data, isn't it awesome?

    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 14, 2008 at 9:30 am

    #898706

  • RE: Help writing function to get decimal from string

    Jeff Moden (11/14/2008)

    Garadin (11/14/2008)

    Not sure if Jeff is gonna slap me for this one, but we'll see.

    Heh... firing porkchop #1... [font="Arial Black"]SLAP![/font] 😛 Ya gotta put a clustered index or,...

    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 14, 2008 at 9:16 am

    #898699

  • RE: Help writing function to get decimal from string

    Dooza (11/14/2008)

    The key thing here for me is making sure the data is correct in the first place. Creating this function has brought to my attention all the variations 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]

    November 14, 2008 at 8:24 am

    #898642

  • RE: Help writing function to get decimal from string

    Yeah, I have a bad habit of "skimming" what people say and just looking at their code. Also, remember that these things will always be limited on what 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]

    November 14, 2008 at 8:16 am

    #898628

  • RE: Move data from one table another based on column value

    You CAN do this with the following code. However, please note that it's not necessarily a good idea. Can you explain the reason this is needed?

    INSERT INTO TableB(TAmount,GAmount,PAmount)

    SELECT...

    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 14, 2008 at 7:58 am

    #898611

  • RE: Help writing function to get decimal from string

    Hah. Great minds think alike! (Although, I'm sure dumb people think alike too, so let's hope we fit the first category).

    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 14, 2008 at 7:53 am

    #898606

  • RE: Help writing function to get decimal from string

    First, allow me to state that this isn't a good idea in the first place. Those numbers should be stripped out of that field and put in a new...

    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 14, 2008 at 7:07 am

    #898553

  • RE: How To utilize log files

    Raises Hand. But... just me. Not like... other people. Those guys screw everything 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 14, 2008 at 6:12 am

    #898509

  • RE: Concatenate three columns but not when the column contains 'Value'

    Is the list of columns to be concatenated dynamic, or is it a fixed list? (IE. it will only ever be columns A,B,C,D,E, and you only want to see...

    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 13, 2008 at 11:42 am

    #898236

  • RE: Repeative data in SELECT

    Thanks for the feedback Art, glad we could help.

    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 13, 2008 at 10:46 am

    #898209

  • RE: Repeative data in SELECT

    Your join seems wrong. (Without knowing what your data/table structure is, I can't say that it IS wrong, but to me it looks wrong)

    Do you have an EmployeeID in...

    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 13, 2008 at 10:38 am

    #898205

  • RE: Help needed: Recursive CTE to flatten text columns into comma delimted field

    I was originally thinking of using FOR XML PATH as well, but the TEXT references and the varchar(max) made me worry about getting the commas in there properly.

    Todd,...

    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 13, 2008 at 8:33 am

    #898140

  • RE: create a stored procedure with insert and update using a cursor

    Paul,

    Since you seem to be unwilling to read the post we've tried to send you to a dozen times so far, let me sum up the gist 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]

    November 13, 2008 at 8:07 am

    #898113

  • RE: Is there a better way for this code?

    Please refer to the link in my signature for how to post table structure/sample data here.

    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 13, 2008 at 7:58 am

    #898105

Viewing 15 posts - 1,111 through 1,125 (of 1,473 total)