Forum Replies Created

Viewing 6 posts - 7,606 through 7,612 (of 7,612 total)

  • RE: Question of the Day for 02 Jun 2005

    I agree with Tim 100%.  The code suggested would not necessarily work and presumably would be less efficient than a not check.  Very frequently when the qod is a T-SQL...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    June 2, 2005 at 8:10 am

    #562526

  • RE: Question of the Day for 04 Jun 2004

    I assumed that too and got it right, but why not make the question match the answer:

    Bill needs to show the day of the week for today's date on a...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    June 4, 2004 at 8:14 am

    #509021

  • RE: Question of the Day for 04 Jun 2004

    Silly premise for the question, since it would require that the highest sales always occur on the current day.  Just don't try rerunning the report

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    June 4, 2004 at 8:03 am

    #509016

  • RE: Need Help removing leading tab

    I think you can remove leading tab(s) directly within a SELECT, without any CASE or loop, for example:

    DECLARE @tabPattern VARCHAR(8)

    SET @tabPattern = '%[^' + CHAR(9) + ']%'

    DECLARE @tabRemove VARCHAR(200)

    SET @tabremove...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    May 7, 2004 at 12:55 pm

    #505705

  • RE: Question of the Day for 04 May 2004

    I would prefer simply:

    CHECK(minit LIKE '[ A-Z]')

    Why split it into two checks?

     

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    May 4, 2004 at 7:34 am

    #505134

  • RE: Crosstab aggregate error, A Stumper!

    You do understand that multiple CASE conditions could be true for the same value and that a single value could be added to every total?

    For example, if cas_lbs...

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

    April 30, 2004 at 7:55 am

    #504830

Viewing 6 posts - 7,606 through 7,612 (of 7,612 total)