Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 7,619 total)

  • RE: need to return all rows from any table containing a value range in a specified column

    Very busy at work, just now was able to complete the code. I'll go ahead and post it as an alternative. I prefer a "template" approach, so that...

    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 3, 2015 at 12:36 pm

    #1824457

  • RE: Finding all relations between tables. How ?

    ben.brugman (9/3/2015)

    Thanks Scott,

    More elegant, more compact and it did uncover a mistake in my solution.

    (My parent_column was not correct, I had not noticed that yet.).

    Thanks,

    Ben

    Edit:

    Second check,

    , COL_NAME(parent_object_id, parent_column_id) as Parent_column

    Does...

    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 3, 2015 at 9:27 am

    #1824352

  • RE: [T-SQL] Question involving Job,Cursors, SP and DBMail

    When you concatenate strings, you must insure that higher-precedence data types are first converted to strings. Try something like this:

    SET @Q1 = N'exec RPT_MailOps '''+CAST(@ID...

    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 2, 2015 at 12:51 pm

    #1824119

  • RE: Get blank ('') in datediff function

    Lynn Pettis (9/2/2015)

    ScottPletcher (9/2/2015)

    Lynn Pettis (9/2/2015)

    ScottPletcher (9/2/2015)

    Finally, there's the cost to fix each issue.

    Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply...

    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 2, 2015 at 9:58 am

    #1824058

  • RE: Get blank ('') in datediff function

    Lynn Pettis (9/2/2015)

    ScottPletcher (9/2/2015)

    Finally, there's the cost to fix each issue.

    Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those specific...

    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 2, 2015 at 9:46 am

    #1824051

  • RE: Delete statement taking too much time..?

    Don't disagree with other comments. But maybe I can give you a quick fix, and maybe not.

    First, you need an index on CSV_Details keyed first by Mark_Rev_No_fab that contains...

    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 2, 2015 at 9:44 am

    #1824050

  • RE: Get blank ('') in datediff function

    Finally, there's the cost to fix each issue.

    Once people are properly convinced that NOLOCK is a bad idea in many, many cases, they simply remove those specific bytes -- "WITH...

    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 2, 2015 at 9:00 am

    #1824025

  • RE: Get blank ('') in datediff function

    Lynn Pettis (9/1/2015)

    Sean Lange (9/1/2015)

    ScottPletcher (9/1/2015)

    Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always 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".

    September 1, 2015 at 1:58 pm

    #1823800

  • RE: Get blank ('') in datediff function

    Lynn Pettis (9/1/2015)

    Sean Lange (9/1/2015)

    ScottPletcher (9/1/2015)

    Honestly, though, I still think that overall the "use identity as the 'default' clustering key" myth is even more damaging than an "almost always 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".

    September 1, 2015 at 1:51 pm

    #1823797

  • RE: Get blank ('') in datediff function

    Jacob Wilkins (9/1/2015)

    ScottPletcher (9/1/2015)

    Jacob Wilkins (9/1/2015)

    I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

    SELECT queries against temporary...

    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 1, 2015 at 1:10 pm

    #1823776

  • RE: Get blank ('') in datediff function

    Sean Lange (9/1/2015)

    ScottPletcher (9/1/2015)

    Sean Lange (9/1/2015)

    ScottPletcher (9/1/2015)

    Sean Lange (9/1/2015)

    Munabhai (9/1/2015)

    drop table #temp

    CREATE TABLE #TEMP

    (

    date1 DATE,

    date2 DATE

    )

    insert into #TEMP values

    ('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

    ('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

    ('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

    SELECT date1, date2,

    CASE

    WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01')...

    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 1, 2015 at 1:08 pm

    #1823773

  • RE: Get blank ('') in datediff function

    Jacob Wilkins (9/1/2015)

    I know it's rather off-topic, but it's an interesting diversion, so I thought I'd just chime in on NOLOCK and temporary tables.

    SELECT queries against temporary tables typically only...

    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 1, 2015 at 12:42 pm

    #1823761

  • RE: Get blank ('') in datediff function

    Sean Lange (9/1/2015)

    ScottPletcher (9/1/2015)

    Sean Lange (9/1/2015)

    Munabhai (9/1/2015)

    drop table #temp

    CREATE TABLE #TEMP

    (

    date1 DATE,

    date2 DATE

    )

    insert into #TEMP values

    ('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

    ('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

    ('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

    SELECT date1, date2,

    CASE

    WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') ...

    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 1, 2015 at 11:58 am

    #1823739

  • RE: Get blank ('') in datediff function

    Sean Lange (9/1/2015)

    Munabhai (9/1/2015)

    drop table #temp

    CREATE TABLE #TEMP

    (

    date1 DATE,

    date2 DATE

    )

    insert into #TEMP values

    ('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

    ('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

    ('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

    SELECT date1, date2,

    CASE

    WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') THEN 0

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

    September 1, 2015 at 11:41 am

    #1823728

  • RE: Filtering Common Table Expression within View

    Instead of a view, look into creating an inline table-valued function. That can function essentially as a parameterized view and is very efficient at doing so.

    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 1, 2015 at 10:27 am

    #1823686

Viewing 15 posts - 4,831 through 4,845 (of 7,619 total)