Forum Replies Created

Viewing 15 posts - 31,276 through 31,290 (of 59,101 total)

  • RE: Duplicate record delete

    preetpalkapoor (2/5/2012)

    Ya we were there before also. Thanks for your help.Actually i am new to this and trying to catch thing quickly.Here you go.....

    create table info (id int,name text,class varchar(50))

    insert...

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

    February 5, 2012 at 12:14 pm

    #1442841

  • RE: sql tricky query

    J Livingston SQL (2/5/2012)

    ....really should have seen that, rather than just coding my "thought" process on how to break it out into what I required....:-)

    Nah. I do things just...

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

    February 5, 2012 at 12:01 pm

    #1442838

  • RE: How can I use this in a function?

    Hi Chrissy,

    You can always use an iTVF or Inline Table Valued Function for such a thing. They're very fast. This one will look a bit odd to you...

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

    February 5, 2012 at 1:21 am

    #1442796

  • RE: Recovery Modals in SQL Server

    The main difference between Full & Bulk logged is that [font="Arial Black"]all[/font] the Bulk Load operaions are minimally logged into the log file of the databases

    Actually, that might not be...

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

    February 5, 2012 at 12:10 am

    #1442795

  • RE: Display salary rank

    What's not to be happy with there? It could be shortened a bit but would still be basicly the same thing.

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

    February 5, 2012 at 12:00 am

    #1442794

  • RE: CASE statement versus dynamic Query

    sergeyledenev (2/4/2012)

    Might be out of scope, but on my last job I was issued to create the similar table structure to keep there the contact information. The demand was 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)

    February 4, 2012 at 11:56 pm

    #1442793

  • RE: sql tricky query

    J Livingston SQL (2/4/2012)

    ...anywhere close???

    prod_id SumQty

    ------- -----------

    p2 11

    p3 16

    if you provide the create table / insert data scripts as I...

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

    February 4, 2012 at 11:37 pm

    #1442791

  • RE: DELETE Statements when using a JOIN - Best Practice

    CELKO (2/4/2012)

    The best practice is not to write dialect SQL and stick to ANSI/ISO syntax

    Heh... you've been saying that for years but I've never seen you post a free link....

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

    February 4, 2012 at 11:11 pm

    #1442790

  • RE: Twist in ISNULL function

    @paul-2,

    What can I say? I was looking to see if anything else needed to be added and you've covered it all. Nicely done.

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

    February 4, 2012 at 3:18 pm

    #1442774

  • RE: Twist in ISNULL function

    CELKO (2/2/2012)

    You misssed a lot.

    Maybe so but the article had a single purpose which was mostly covered.

    ISNULL takes only 2 parameters whereas COALESCE takes variable number of parameters

    Something else might...

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

    February 4, 2012 at 3:14 pm

    #1442773

  • RE: Need Query Help Urgent

    Jing. (2/3/2012)

    create table student ( stdnt_id int, stdnt_name varchar(50),stdnt_activity SMALLINT )

    go

    INSERT INTO student

    select 1, 'kiran', 5 UNION ALL

    select 1 ,'kiran', 10 UNION ALL

    select 1 ,'kiran', 15 UNION ALL

    select...

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

    February 4, 2012 at 7:50 am

    #1442747

  • RE: Need Query Help Urgent

    ashutosh.kumarpandey (2/3/2012)

    Its simple:-

    Select * from student where stdnt_id not in (select stdnt_id from student where stdnt_activity=15)

    this will take sometime however your can easily optimize it but that I will leave...

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

    February 3, 2012 at 11:02 am

    #1442554

  • RE: Are the posted questions getting worse?

    GilaMonster (2/2/2012)

    Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up with...

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

    February 3, 2012 at 6:37 am

    #1442384

  • RE: Need Query Help Urgent

    prashantgoswami2007 (2/2/2012)

    Actually, you might want to explain why you wrote code that takes 10 times longer to run, returns duplicate answers, can't be easily modified to solve for other similiar...

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

    February 3, 2012 at 6:29 am

    #1442378

  • RE: Need Query Help Urgent

    srikant maurya (2/2/2012)

    Try This SQL

    create table student ( stdnt_id int, stdnt_name varchar(50),stdnt_activity SMALLINT )

    go

    INSERT INTO student

    select 1, 'kiran', 5 UNION ALL

    select 1 ,'kiran', 10 UNION ALL

    select 1...

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

    February 3, 2012 at 6:22 am

    #1442374

Viewing 15 posts - 31,276 through 31,290 (of 59,101 total)