Forum Replies Created

Viewing 15 posts - 25,591 through 25,605 (of 59,099 total)

  • RE: palindrome

    sqlserver12345 (10/20/2013)

    I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks

    I'm curious... please explain why you don't want to use "REVERSE".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 20, 2013 at 11:43 am

    #1659982

  • RE: Tip: Calculated Table Truncate

    jonysuise (10/20/2013)

    Hi simonholzman 14059, and welcome to the forum 😀

    To delete a large number of rows switch the recovery model of your database (in your development environment) to bulk-log, run...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 20, 2013 at 11:34 am

    #1659981

  • RE: How to hide sensitive data in SQL 2000 table

    homebrew01 (10/20/2013)

    We were allowed to store CC numbers, but had to have various safeguards in place to be PCI compliant.

    When you say you "were allowed to store CC numbers", do...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 20, 2013 at 10:53 am

    #1659979

  • RE: Export Import entire database (or best method to accomplish this)

    ken def (10/19/2013)

    Hi

    I need to clean up a database. Main reason: datafiles have grossly disparate sizes. I'd like to export entire database (or some other meaningful method), resize...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:55 pm

    #1659947

  • RE: Need help with simple ETL strategy with SSIS

    I don't use SSIS, so no help there. I just thought I'd mention that this would be incredibly easy and simple to do with a little Dynamic SQL.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:47 pm

    #1659946

  • RE: DATE

    To help us help you, rather than posting a picture of the data, please see the first link under "Helpful Links" in my signature line below and post your data...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:41 pm

    #1659945

  • RE: Query Optimization help

    - Win (10/11/2013)

    Thanks for your replies...

    I will consider all of the posts and replies..

    I can only hope that's true.

    Tell your company that it's no longer lawful to embed SSN's in...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:25 pm

    #1659944

  • RE: Listing Years based on range

    born2achieve (10/19/2013)

    Also, none of the above queries executing correctly. i tried to check the query is working fine or not using

    http://sqlfiddle.com. Somethign wrong with the declaration. could you please...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:22 pm

    #1659943

  • RE: Listing Years based on range

    born2achieve (10/19/2013)

    Hi Jeff Thanks for your response and great article. But i have a concern that you are using custom year next to the declaration.

    SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

    I don't want...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 10:18 pm

    #1659942

  • RE: Returning part of a string

    If the audit strings won't ever be longer than 8K, here's one way. It's quite generic so it won't necessarily be the fastest method but will still perform quite...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 9:35 pm

    #1659940

  • RE: Listing Years based on range

    AmarettoSlim (10/19/2013)

    Can I ask why you don't want a loop? Recursion via a common table expression (CTE) can be your friend in this case.

    DECLARE @fromYear DATETIME, @toYear DATETIME

    SELECT @fromYear='1913-01-01', @toYear='1998-01-01'

    ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 5:35 pm

    #1659936

  • RE: Tip: Calculated Table Truncate

    It should handle foreign key constraints okay since the Truncate does not check them but I make no promises !

    You can't truncate a table that has foreign keys...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 5:23 pm

    #1659935

  • RE: AVG time (hh:mm:ss) in SSRS

    Sean Lange (10/18/2013)

    Jeff Moden (10/17/2013)

    mister.magoo (10/17/2013)

    ...Time Of Day is not something you can average...

    Gosh... I have to disagree with that statement that you and Sean made. What if the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 5:12 pm

    #1659932

  • RE: how to handled Nulls and empty values in sql server

    jonysuise (10/19/2013)

    Jeff Moden (10/18/2013)

    jonysuise (10/18/2013)

    Hi asranantha, 😀

    I would use COALESCE AND CASE, because it's SQL standard.

    I would use just ISNULL AND NULLIF (like Sean did) because you don't have...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 19, 2013 at 5:03 pm

    #1659931

  • RE: how to handled Nulls and empty values in sql server

    jonysuise (10/18/2013)

    Hi asranantha, 😀

    I would use COALESCE AND CASE, because it's SQL standard.

    I would use just ISNULL AND NULLIF (like Sean did) because you don't have unexpected datatype precedence...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 18, 2013 at 3:56 pm

    #1659864

Viewing 15 posts - 25,591 through 25,605 (of 59,099 total)