Forum Replies Created

Viewing 15 posts - 7,036 through 7,050 (of 7,619 total)

  • RE: SP Help...

    Is the name "IDeleted" on the INSERT statement just a typo for "IsDeleted", as it appears on the table? Or could the mistyped column name be causing you the...

    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 10, 2012 at 4:40 pm

    #1567204

  • RE: An alternative to split for performance benefits?

    Jeff Moden (12/7/2012)

    Rob-350472 (12/7/2012)

    I tried with 0x0a as the rowterminator instead but it generated the same results, I need to play some more with this (I've only used it once...

    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 10, 2012 at 4:27 pm

    #1567201

  • RE: Trend Rolling Table

    Replication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.

    Also, do you need to capture UPDATE activity or just INSERTs?

    Finally, are you on Enterprise or...

    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 10, 2012 at 4:17 pm

    #1567199

  • RE: Delete records in group - but not all

    I would think the old, trusty MAX() would be clearer and less overhead than the mirrored function:

    DELETE FROM tn

    FROM dbo.tablename tn

    INNER JOIN (

    SELECT location, MAX(bookid) 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".

    December 10, 2012 at 4:12 pm

    #1567195

  • RE: Straight & Reverse Check - kcehc eserveR & Straight

    Yes, if you can, it would be much better to store from and to currencies as separate columns.

    But, either way, you don't need to store 2 conversion rates, only one,...

    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 10, 2012 at 4:03 pm

    #1567193

  • RE: hours,minutes Between Date Format Of Type Yyyymmddhhmmss

    --If the final total will be <= 24 hrs, you can do this:

    SELECT CONVERT(char(5), DATEADD(MINUTE, DATEDIFF(MINUTE, STUFF(STUFF(date_column1, 9, 0, ' '), 12, 0, ':'), STUFF(STUFF(date_column2, 9, 0, ' '), 12,...

    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 7, 2012 at 1:37 pm

    #1566748

  • RE: Simple SQL Question...

    One or more them could also be exception/override tables. They may be empty in your case because currently you don't have any exceptions to normal processing rules/conditions. But...

    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 7, 2012 at 11:38 am

    #1566715

  • RE: Multivalue Parameters with Stored Procedure

    DarthBurrito (12/7/2012)

    Let me add that I'm using this SP for a SSRS report. As the code I provided stands, the SP has one parameter called Products. So the parameter accepts...

    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 7, 2012 at 11:35 am

    #1566713

  • RE: Exercises in t-SQL

    Jeff Moden (12/6/2012)

    patrickmcginnis59 (12/6/2012)

    Jeff Moden (12/6/2012)

    patrickmcginnis59 (12/6/2012)

    Jeff Moden (12/4/2012)

    So far as no offer being extended, that's fine because I don't want to work for a company that wants a code...

    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 7, 2012 at 8:08 am

    #1566626

  • RE: Exercises in t-SQL

    Jeff Moden (12/5/2012)

    ScottPletcher (12/5/2012)

    Jeff Moden (12/4/2012)

    ScottPletcher (12/4/2012)

    It would take far longer than 2 minutes to give the full background you wanted.

    This for a simple, introductory interview q, when I often...

    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 5, 2012 at 9:47 pm

    #1566001

  • RE: Get Rid of All Those Pesky 1 MB File Growth DB Files

    Yeah, the 10% is awful. I'm afraid I don't see the point of resetting to something almost as bad.

    Why not create default growth tables based on total size, one...

    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 5, 2012 at 7:09 pm

    #1565981

  • RE: Exercises in t-SQL

    Jeff Moden (12/4/2012)

    ScottPletcher (12/4/2012)

    It would take far longer than 2 minutes to give the full background you wanted.

    This for a simple, introductory interview q, when I often had two more...

    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 5, 2012 at 7:02 pm

    #1565980

  • RE: Calculate weekend

    Pete Cox (12/4/2012)

    YYYYMMDD is in fact the Basic date format proposed by ISO8601.

    YYYY-MM-DD is named the Extended format.

    Using either is OK by the standard.

    Excellent point, and quite correct (I just...

    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 4, 2012 at 10:00 am

    #1565413

  • RE: Exercises in t-SQL

    Jeff Moden (12/4/2012)

    ScottPletcher (12/3/2012)

    Jeff Moden (12/3/2012)

    If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in...

    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 4, 2012 at 9:48 am

    #1565407

  • RE: Exercises in t-SQL

    Jeff Moden (12/3/2012)

    If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in the area of...

    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 3, 2012 at 5:15 pm

    #1565084

Viewing 15 posts - 7,036 through 7,050 (of 7,619 total)