Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,473 total)

  • RE: CTE Question

    Your CTE is fine, all that needs to change is your final select.

    SELECT MAX(an.id)...

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

    #903761

  • RE: Question regarding horse racing database query in SQL Server 2005 Express

    Good call Barry.

    [font="Courier New"]SELECT DISTINCT

       D.Ohorseid,

       RC.RaceCount,

       WC.WinCount,

       TPM.TotalPrizeMoney,

       CASE WHEN ISNULL(RC.RaceCount,0) = 0 THEN 0

            WHEN ISNULL(WC.WinCount,0) = 0 THEN 0

            ELSE TPM.TotalPrizeMOney / (WC.WinCount / RC.RaceCount)

            END PrizeMoneyCalc

    FROM decouting...

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

    #903744

  • RE: Question regarding horse racing database query in SQL Server 2005 Express

    LEFT JOIN (SELECT OHorseID, SUM(b.rprize1) TotalPrizeMoney

    FROM outing 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 26, 2008 at 7:35 am

    #903718

  • RE: Generalising a query using metadata

    I get that. However, if you can show me a specific example of what you want to return, I can understand what you're trying to accomplish. Different metadata 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 26, 2008 at 6:27 am

    #903675

  • RE: returning top n using partition by

    All that lurking and you haven't seen us sending people to the same post over and over? :hehe: Please refer to the article in my signature for an 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 26, 2008 at 6:23 am

    #903673

  • RE: Generalising a query using metadata

    Could you be more specific? Providing a table with definition and exactly what you want to return from that table would help. See the link in my signature...

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

    #903665

  • RE: CTE Question

    For the sample data provided, please give your expected results.

    Are they:

    10031832

    100311592

    100311602

    100311612

    800003925051

    10031140012

    10031800003920

    ?

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

    #903663

  • RE: How to reset identity count in sql tables?

    Drop and recreate the table.

    (You can use SSMS to generate a sql script for the table)

    That said, the identity column is really there for uniqueness and the actual numbers shouldn't...

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

    #903492

  • RE: Question regarding horse racing database query in SQL Server 2005 Express

    Yerp, change this:

    TPM.TotalPrizeMOney / (WinCount / RaceCount)

    To this:

    CASE WHEN RaceCount = 0 THEN 0

    WHEN WinCount = 0 THEN 0

    ...

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

    #903491

  • RE: Question regarding horse racing database query in SQL Server 2005 Express

    Please refer to the link in my signature for how to post table structure / sample data for future questions. Doing so would have gotten you a tested answer....

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

    #903467

  • RE: problem with function

    Are you running this through ASP?

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

    #903463

  • RE: How to write a script to display a "date" format in view (SQL Server 2005)

    When you make the modifications Lynn suggested, please do it in this thread rather than creating another one. Creating multiple threads on the same issue is confusing and annoys...

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

    #903455

  • RE: Return a set of most recent records with same timestamp

    Please refer to the article in my signature on how to post sample data on this forum.

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

    #903452

  • RE: WHERE NOT EXISTS

    Grats on Carpal Lynn!

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

    #903450

  • RE: return yes/no rather than true/false

    You just add in the extra handler:

    Select Case @tst1 When 1 Then 'Yes' Else 'No' END ,

    Case @tst2 When 1 Then 'Yes'...

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

    #903447

Viewing 15 posts - 1,036 through 1,050 (of 1,473 total)