Forum Replies Created

Viewing 15 posts - 721 through 735 (of 7,613 total)

  • Reply To: Substring charindex Mid - Get name within String

    Need the sample data in a directly usable format, not in a picture, which we can't write T-SQL against.

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

    July 28, 2022 at 5:13 pm

    #4069597

  • Reply To: Get Saturday from the week specified in column

    The idea being that you can change the starting day to adjust for any day of the week.  0=Mon, 1=Tues, ..., 5= Sat, 6=Sun.

    For example, if you wanted the next...

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

    July 27, 2022 at 11:31 pm

    #4069183

  • Reply To: Get Saturday from the week specified in column

    I use a consistent method for any day, so I don't use techniques like the one given.

    Instead, I recommend:

    DATEADD(DAY, -DATEDIFF(DAY, 5, S1SDAT) % 7 + 7, S1SDAT)

    for example:

    SELECT

    S1SDAT,

    DATEADD(DAY, -DATEDIFF(DAY, 5,...

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

    July 27, 2022 at 11:29 pm

    #4069179

  • Reply To: Index created in the last few days

    There is no query that will tell you what index(es) were created in the last few days.  SQL Server itself does not store that info anywhere.

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

    July 27, 2022 at 12:54 am

    #4068689

  • Reply To: Using Lag while getting previous row record not working

    I'm very confused about what final results you want to see.  Here's a query that returns all columns; adjust it to return only the columns you want.

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

    July 25, 2022 at 7:10 pm

    #4068055

  • Reply To: Ordering Collation of Linked Server

    Paul White and/or Itzik Ben-Gan have done write ups on the problem with non-unique sorts.  The solution is indeed to make sure you specify ORDER BY values that will insure...

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

    July 25, 2022 at 6:16 pm

    #4068031

  • Reply To: How to get count and values merged by string aggregate 

    select m.CompanyId,m.PackageId,m.partsfamilyid,max(m.countparts) as countparts,
        STRING_AGG('(' + CONVERT(VARCHAR(8000), countPartsValues) + ')' + CONVERT(VARCHAR(8000), MSLIDValue),'|') WITHIN GROUP(ORDER BY MSLIDValue ASC) AS MSLDIFF  
    from #final m
    inner...

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

    July 21, 2022 at 5:38 pm

    #4066568

  • Reply To: Finding the row before the negative value 

    SELECT d1.*
    FROM #DETAIL d1
    WHERE d1.IDR < (SELECT MIN(d2.IDR) FROM #DETAIL d2 WHERE d2.ID = d1.ID AND d2.BALANCE < 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".

    July 20, 2022 at 4:59 pm

    #4066066

  • Reply To: @@DBTS changes by itself (overnight?)

    What is the definition of table1?

     

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

    July 20, 2022 at 3:46 pm

    #4066047

  • Reply To: Scanning on different Index

    VastSQL wrote:

    Hi Experts,

    Below query is scanning index on column 'created' where I was expecting it to scan on CID which is the 'where' clause and PK?

    Can you help me understand...

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

    July 20, 2022 at 3:38 pm

    #4066046

  • Reply To: pull data every 3 hrs

    Ok, fair enough

    SELECT 
        dtstamp, equipment_id, temperature
    FROM (
        SELECT *, 
            ROW_NUMBER() OVER(PARTITION BY...

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

    July 19, 2022 at 8:52 pm

    #4065591

  • Reply To: pull data every 3 hrs

    You stated nothing about equipment_id in your original post.  How am I supposed to include logic for your equipment_ids when you tell us nothing about them?!

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

    July 19, 2022 at 8:23 pm

    #4065582

  • Reply To: pull data every 3 hrs

    Maybe?

    SELECT 
        dtstamp, equipment_id, temperature
    FROM (
        SELECT *, 
            ROW_NUMBER() OVER(PARTITION BY DATEDIFF(HOUR, 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".

    July 19, 2022 at 4:52 pm

    #4065428

  • Reply To: Shrink Database or Create Empty Database after 4TB free space

    Gen script should be able to do that, just specify the correct scripting options in SSMS before you gen the script.

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

    July 18, 2022 at 6:53 pm

    #4064951

  • Reply To: Left Join with reference data.

    Jeff Moden wrote:

    My question would be, why are you using two tables to do one thing?  It looks to me like it should be a single table because there appears 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".

    July 15, 2022 at 9:07 pm

    #4063994

Viewing 15 posts - 721 through 735 (of 7,613 total)