Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 1,473 total)

  • RE: Help writing function to get decimal from string

    Jeff Moden (11/18/2008)

    The really good part about it all is that no matter what goes wrong, I always learn something new even if it's only how to "read minds" 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]

    November 18, 2008 at 5:57 am

    #899840

  • RE: 2 rows of data into 1

    Take a look at this post, the concept is the same:

    http://www.sqlservercentral.com/Forums/Topic602485-1291-1.aspx

    If you need help applying this method to your situation, please provide table DDL/sample data as inserts.

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

    #899838

  • RE: SQLQuery for SQl 2000

    Heh, I was about to post roughly the same query, and specifically waited until you posted because I saw you reading it too :P.

    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 17, 2008 at 2:29 pm

    #899573

  • RE: SQLQuery for SQl 2000

    If you only want citations with a date > 11/12/05 that don't exist in the table, add

    AND C.Date > '11/12/2005'

    to the end of Lynn's query.

    Also, for future reference,...

    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 17, 2008 at 2:26 pm

    #899569

  • RE: Consolidating updates?

    I was counting those as gaps, even though the new enrollment period started the next day. Let me see if I can re-work it to not count those.

    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 17, 2008 at 1:13 pm

    #899514

  • RE: Consolidating updates?

    My final select query was wrong. It's always the little things! If that's what you were using to check all of your tests, that explains the results. After...

    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 17, 2008 at 12:53 pm

    #899505

  • RE: Concat mutiple rows into one row

    Here's an example. Jeff may have some fine tuning to suggest for this.

    [font="Courier New"]

    ------------- CTE to concatenate U_soBLNo -----------------

    ;WITH ConcatB(DocDate, [Shipping Line],CB) AS(

    SELECT QC.DocDate,[Shipping Line],STUFF((SELECT

            ', ' + U_soBLNo

        FROM

            [Query_Concat] QC2

        WHERE...

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

    #899336

  • RE: Array problem

    Have a look at this:

    http://www.sqlservercentral.com/articles/T-SQL/63003/

    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 17, 2008 at 6:59 am

    #899306

  • RE: query :

    [font="Courier New"]

    --------------- CREATE SAMPLE DATA TABLE ------------------

    DECLARE @a TABLE(

    A  VARCHAR(5),

    B  VARCHAR(5))

    INSERT INTO @a(A,B)

    SELECT 'a','x1' UNION ALL

    SELECT 'a','x2' UNION ALL

    SELECT 'a','x3' UNION ALL

    SELECT 'b','y1' UNION ALL

    SELECT 'b','y2'

    -----------------------------------------------------------

    ------------- CTE to...

    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 17, 2008 at 6:56 am

    #899304

  • RE: Math Functions within Case When

    My pleasure, 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 14, 2008 at 1:03 pm

    #898844

  • RE: Math Functions within Case When

    Omair Aleem (11/14/2008)

    Hey Thanks buddy.. yes not your fault... I'm sorry I didnt let you know that it wasnt the only thing I was working with.. but is your query...

    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 12:53 pm

    #898836

  • RE: Math Functions within Case When

    You've been attacked by Single quotes! FIND COVER! (Sorry, it's Friday, and I need a beer)(And the Select and from's I told you to add were from when I...

    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 12:39 pm

    #898823

  • RE: Math Functions within Case When

    Yerp, that's correct as it is. Just add a SELECT to the beginning, and a FROM, and replace the column names with your actual field names, and you're 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 14, 2008 at 12:00 pm

    #898806

  • RE: Math Functions within Case When

    So, what's the 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 14, 2008 at 11:55 am

    #898801

  • RE: if else statement

    http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx

    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 11:21 am

    #898778

Viewing 15 posts - 1,096 through 1,110 (of 1,473 total)