Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 7,614 total)

  • RE: how to calculate dates difference in a same table

    SELECT first_appointment.*, next_appointment.*

    FROM (

    SELECT customer#, MIN(appoinment_date) AS appointment_date

    FROM table_name

    GROUP BY customer#

    HAVING MIN(appointment_date) >= '20140101'...

    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 4, 2015 at 3:30 pm

    #1824783

  • RE: First Occurance of the string from text

    You have at least one rule missing. For example, in

    Text1=

    'ABNAGENDRACSURENDRADJITHENDRAXNARENDRABVEERNDARAXDRMNDRAXRVINDRABNAGENDRACSURENDRADJITHEN'

    The first A not followed by a B, C or D is "AGENDR". Why is that "A" excluded?

    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 4, 2015 at 2:33 pm

    #1824782

  • RE: logging without blocking?

    tobe_ha (9/4/2015)

    ScottPletcher (9/4/2015)

    Does the log table have an identity column? Did you try removing that column and see if the table is still locked? Typically multiple tasks 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".

    September 4, 2015 at 1:28 pm

    #1824773

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

    Jacob Wilkins (9/4/2015)

    Ah, thanks for posting that. I'd been having more trouble finding a 2008 instance than I'd expected.

    So it seems 2008 (not R2) is the same as the others...

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

    #1824771

  • RE: logging without blocking?

    Does the log table have an identity column? Did you try removing that column and see if the table is still locked? Typically multiple tasks should be able...

    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 4, 2015 at 10:31 am

    #1824739

  • RE: Difference count

    You certainly don't need a calendar table for that simple a calculation! All you need is:

    SELECT (DATEDIFF(MONTH, 0, @enddate) / 3) - (DATEDIFF(MONTH, 0, @startdate) / 3) + 1

    declare...

    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 4, 2015 at 10:24 am

    #1824735

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

    Hrothgar (9/4/2015)

    That's a very good and very helpful solution; very many thanks.

    As the results seem to come out in an arbitrary order, or at least in an order that I...

    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 4, 2015 at 8:19 am

    #1824678

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

    Jacob Wilkins (9/1/2015)

    ScottPletcher (9/1/2015)

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

    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 4:38 pm

    #1824508

  • RE: Huge headache to work with big data

    I can't see the screenshot. A screenshot is pretty useless anyway. Actual text would be much better.

    But, in short, here's the approach I recommend:

    1) encode the large varchar...

    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 2:29 pm

    #1824488

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

    Lynn Pettis (9/3/2015)

    ScottPletcher (9/3/2015)

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

    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:47 pm

    #1824461

  • 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

Viewing 15 posts - 4,816 through 4,830 (of 7,614 total)