Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 7,619 total)

  • RE: Select query to determine unique values

    SELECT

    GrpID, GrpName,

    ISNULL(NULLIF(MAX(CASE WHEN Spc <> 'Mixed' THEN Spc ELSE '' END), ''), 'Mixed') AS Spc

    FROM #mytable

    GROUP BY

    GrpID, GrpName

    HAVING

    MAX(CASE WHEN Spc = 'Mixed' AND PrvName =...

    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".

    December 3, 2012 at 5:09 pm

    #1565082

  • RE: plant count really high-Activity Monitor

    Hmm, something seems odd.

    SQL should be able to easily do "simple parameterization" -- the old name, "auto-parameterization", seems clearer to me -- on that query. That is, SQL should...

    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".

    December 3, 2012 at 4:40 pm

    #1565075

  • RE: SPLIT RANGE TOOK 10 HRS to Complete

    What was the status of the log file when you ran the command? How large was the log, how much space was free, and what was the Autogrowth amount?

    Be...

    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".

    December 3, 2012 at 4:26 pm

    #1565069

  • RE: Calculate weekend

    CELKO (12/1/2012)

    Please learn to use the ISO-8601 date formats; it is the only one allowed in Standard SQL and the other ISO Standards. Use the DATEADD() function for this.

    Or,...

    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".

    December 3, 2012 at 10:22 am

    #1564968

  • RE: Exercises in t-SQL

    CELKO (12/1/2012)

    CHECK (test_nbr BETWEEN 1 AND 3),

    Seriously, test_nbr limited to 3? What about previous classes? And classes for the next semester? Test_nbr would be identifier,...

    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".

    December 3, 2012 at 8:50 am

    #1564926

  • RE: Exercises in t-SQL

    Jeff Moden (11/30/2012)

    ScottPletcher (11/30/2012)

    Jeff Moden (11/30/2012)

    ScottPletcher (11/30/2012)

    Jeff Moden (11/29/2012)

    That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single...

    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".

    December 3, 2012 at 8:41 am

    #1564914

  • RE: Exercises in t-SQL

    CELKO (12/1/2012)

    I use this query as extra credit for my students when I teach a SQL class. ... This is much trickier than it sounds at first....

    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".

    December 3, 2012 at 8:33 am

    #1564909

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ... and got some pretty mediocre answers from (supposedly) experienced and skilled T-SQLers.

    I am not be surprised when good skilled T-SQLers come up with stupid answers on paper...

    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".

    November 30, 2012 at 4:50 pm

    #1564606

  • RE: Exercises in t-SQL

    capnhector (11/30/2012)

    ScottPletcher (11/30/2012)

    Eugene Elutin (11/30/2012)

    ScottPletcher (11/30/2012)

    ...

    In the interests of being thorough, I added a Message to my proposed solution back to them:

    SELECT

    ...as above...,

    ...

    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".

    November 30, 2012 at 4:45 pm

    #1564605

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ScottPletcher (11/30/2012)

    ...

    In the interests of being thorough, I added a Message to my proposed solution back to them:

    SELECT

    ...as above...,

    CASE WHEN...

    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".

    November 30, 2012 at 4:13 pm

    #1564599

  • RE: How to use values keyword as parameter of a function

    Jeff Moden (11/29/2012)

    capnhector (11/29/2012)

    EDIT: This is also for me to play with a couple of things and get more experience with them. so it may not be fast...

    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".

    November 30, 2012 at 1:53 pm

    #1564570

  • RE: Help On Execution Plan Status

    Grant Fritchey (11/30/2012)

    And the indexes have to be selective enough to be useful for a seek or you'll get scans. Same things apply to non-clustered indexes too.

    For lots more detail...

    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".

    November 30, 2012 at 12:28 pm

    #1564526

  • RE: Bulk Insert Row Terminator Woes

    rwm972 (11/30/2012)

    Hi All,

    I'm trying to bulk insert a pipe-delimited file with <CR><LF> as a row terminator. The problem is some fields may contain <CR><LF>. So, I've asked the client to...

    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".

    November 30, 2012 at 12:27 pm

    #1564525

  • RE: Exercises in t-SQL

    Eugene Elutin (11/30/2012)

    ... and got some pretty mediocre answers from (supposedly) experienced and skilled T-SQLers.

    I am not be surprised when good skilled T-SQLers come up with stupid answers on paper...

    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".

    November 30, 2012 at 10:54 am

    #1564498

  • RE: Exercises in t-SQL

    Jeff Moden (11/30/2012)

    ScottPletcher (11/30/2012)

    Jeff Moden (11/29/2012)

    That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single query". It's...

    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".

    November 30, 2012 at 10:49 am

    #1564495

Viewing 15 posts - 7,051 through 7,065 (of 7,619 total)