Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 7,613 total)

  • RE: Unable to convert character to datetime

    Rando (1/2/2014)

    Still searching for a solution. Scott's solution yield's syntax errors and Chris' solution yields the entire date field...

    Again, I'm just looking for the results to be the following;

    Date: 12/30/2013

    Time:...

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

    January 2, 2014 at 8:11 am

    #1676916

  • RE: Unable to convert character to datetime

    SELECT

    CONVERT(varchar(10), CAST(CounterDateTime AS datetime), 101) AS Date,

    RIGHT(CONVERT(varchar(20), CAST(CounterDateTime AS datetime), 100), 7) AS Time

    FROM table

    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 30, 2013 at 3:42 pm

    #1676494

  • RE: Split a variable length string without using a WHILE loop

    Jeff Moden (12/24/2013)

    ScottPletcher (12/24/2013)

    If you don't have any data longer than 24 bytes (or so), it might be easier just to "brute STUFF" it:

    Awesome! I don't believe anything will...

    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 24, 2013 at 1:24 pm

    #1675827

  • RE: Split a variable length string without using a WHILE loop

    If you don't have any data longer than 24 bytes (or so), it might be easier just to "brute STUFF" it:

    WITH SampleData (MyStr) AS

    (

    SELECT '12345678'

    ...

    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 24, 2013 at 10:45 am

    #1675802

  • RE: SYNTAX Help please...

    Jeff Moden (12/20/2013)

    ScottPletcher (12/20/2013)

    Evil Kraig F (12/20/2013)

    ScottPletcher (12/20/2013)

    Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on...

    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 23, 2013 at 7:17 am

    #1675599

  • RE: SYNTAX Help please...

    Evil Kraig F (12/20/2013)

    ScottPletcher (12/20/2013)

    Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

    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 20, 2013 at 5:16 pm

    #1675347

  • RE: SYNTAX Help please...

    Evil Kraig F (12/20/2013)

    ScottPletcher (12/20/2013)

    Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

    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 20, 2013 at 5:05 pm

    #1675344

  • RE: SYNTAX Help please...

    Evil Kraig F (12/20/2013)But, I'd like to bring us back to the origination of this minor alteration in the direction of this topic, and that's SARGability and effeciency and if...

    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 20, 2013 at 4:50 pm

    #1675339

  • RE: SYNTAX Help please...

    Evil Kraig F (12/20/2013)

    ScottPletcher (12/20/2013)

    There could be great harm in it if either (1) SQL could have done seeks on both terms and produced the final output more efficiently than...

    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 20, 2013 at 4:24 pm

    #1675337

  • RE: SYNTAX Help please...

    Jeff Moden (12/20/2013)

    ScottPletcher (12/20/2013)

    Jeff Moden (12/20/2013)

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent...

    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 20, 2013 at 2:40 pm

    #1675317

  • RE: SYNTAX Help please...

    Jeff Moden (12/20/2013)

    ScottPletcher (12/19/2013)

    I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use...

    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 20, 2013 at 12:48 pm

    #1675291

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    Snargables (12/19/2013)

    I had to create an index that added all the columns in the include of the index. This was because i created a function that has to return all...

    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 19, 2013 at 2:44 pm

    #1675014

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    wolfkillj (12/19/2013)

    ScottPletcher (12/19/2013)

    Jeff Moden (12/18/2013)

    ScottPletcher (12/18/2013)

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than...

    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 19, 2013 at 2:03 pm

    #1674994

  • RE: need help on design of database for student registration system

    Sigerson (12/19/2013)

    Grant Fritchey (12/18/2013)

    I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while...

    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 19, 2013 at 8:10 am

    #1674834

  • RE: How to avoid KeyLookpu in Execution Plan of a Query ?

    Jeff Moden (12/18/2013)

    ScottPletcher (12/18/2013)

    If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having 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".

    December 19, 2013 at 8:04 am

    #1674830

Viewing 15 posts - 6,271 through 6,285 (of 7,613 total)