Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 7,619 total)

  • RE: How can I get a set Date and Time Range between Yesterday and Today?

    drew.allen - Tuesday, September 18, 2018 11:56 AM

    This is shorter, but many people don't like it for some reason.

    SELECT DATEADD(DAY,...

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

    September 18, 2018 at 12:10 pm

    #2006185

  • RE: Is there a way to identify the offending column in "conversion failed when converting the varchar value to data type int"?

    I'm guessing the error was about conversion to int, based on your comments, but it would be nice to be sure.
    If so, run a pre-audit on the source data...

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

    September 18, 2018 at 12:01 pm

    #2006183

  • RE: How can I get a set Date and Time Range between Yesterday and Today?


    SELECT
      @StartDt = DATEADD(HOUR, 6, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0)),
      @EndDt = DATEADD(HOUR, 1, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0))

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

    September 18, 2018 at 11:47 am

    #2006177

  • RE: Is there a better way to write a simple query?

    Lynn Pettis - Tuesday, September 18, 2018 7:49 AM

    Chris Wooding - Tuesday, September 18, 2018 7:11 AM

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

    September 18, 2018 at 11:19 am

    #2006170

  • RE: Is there a better way to write a simple query?

    Chris Wooding - Tuesday, September 18, 2018 7:11 AM

    ScottPletcher - Monday, September 17, 2018 3:24 PM

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

    September 18, 2018 at 11:17 am

    #2006169

  • RE: Why such a big log size?

    MERGE is notorious for some performance issues. You might want to try "UPSERT" -- an equivalent UPDATE followed by an INSERT.

    For overall performance,, make sure you have...

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

    September 17, 2018 at 3:41 pm

    #2006062

  • RE: Is there a better way to write a simple query?

    100% not using a JOIN clause screams "noob".

    But I see many more issues.

    A serious one is not including a schema name before the table names. ...

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

    September 17, 2018 at 3:24 pm

    #2006061

  • RE: Is there a better way to write a simple query?

    sgmunson - Monday, September 17, 2018 1:40 PM

    thelenj - Monday, September 17, 2018 1:21 PM

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

    September 17, 2018 at 3:02 pm

    #2006060

  • RE: Multiple Join Behaviour

    drew.allen - Monday, September 17, 2018 11:50 AM

    RonKyle - Friday, September 14, 2018 1:04 PM

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

    September 17, 2018 at 2:56 pm

    #2006059

  • RE: How do I write a record for each day in a date range???

    Eirikur Eiriksson - Monday, September 17, 2018 3:13 AM

    The quickest I've found (so far) is to subtract the day of month...

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

    September 17, 2018 at 12:36 pm

    #2006014

  • RE: Stored Procedure using WITH

    Remove the comma from the last column name before the FROM:
    ...
    hd--, --<--remove this comma
    ...
    from icr_emp

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

    September 12, 2018 at 2:59 pm

    #2005515

  • RE: Does a check constraint with UDF has performance impact on Query?

    You do need a separate codes table to do what you want.  But that table could be fully maintained automatically by triggers on the "master table".  That is, you wouldn't...

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

    September 12, 2018 at 10:15 am

    #2005458

  • RE: Dynamic creating indexes

    My preference has been to store the original sys.indexes and sys.index_columns rows rather than storing what you generated from them.  You can always generate it later if you need 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".

    September 11, 2018 at 4:28 pm

    #2005349

  • RE: Delete Old Tables

    Jeff Moden - Monday, September 10, 2018 8:04 AM

    unas_sasing - Thursday, September 6, 2018 9:01 PM

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

    September 10, 2018 at 8:24 am

    #2005089

  • RE: Selecting Min of multiple values, including an operation

    Not 100% sure of the specific MIN rules, but something like this should do it, and far more efficiently:


    SELECT DISTINCT

    ire.SourceId as...

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

    September 7, 2018 at 10:49 am

    #2004921

Viewing 15 posts - 3,166 through 3,180 (of 7,619 total)