Forum Replies Created

Viewing 15 posts - 48,526 through 48,540 (of 59,102 total)

  • RE: conversion error

    muralikrishna37 (8/31/2008)

    Hi Jeff,

    when i fit Int datatype it shows error.tell me which data type i have to fit here.

    the problem is blank row(empty row).how to take the data into 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)

    August 31, 2008 at 9:33 am

    #865492

  • RE: String or binary data would be truncated.

    balbirsinghsodhi (8/31/2008)

    Now, I ran the code which Jeff has provided. It's working fine when I run as a select command but when I try to convert into a stored procedure...

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

    August 31, 2008 at 9:23 am

    #865488

  • RE: Cursor

    simon phoenix (8/31/2008)

    Hi

    Jeff

    Everything worked out perfect, exactly what i wanted. After a long time , i am going to have good night sleep. I am not scared of going to...

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

    August 31, 2008 at 9:14 am

    #865482

  • RE: Cursor

    --===== Show first and last PRD and date of each SetSequence

    SELECT yt.SetSequence,

    MAX(CASE WHEN d.MinID = yt.ID THEN PRD END) AS MinPrd,

    ...

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

    August 30, 2008 at 11:43 pm

    #865457

  • RE: Using UNION ALL with ORDER BY NEWID()

    Thanks for the feedback, Juan. 🙂

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

    August 30, 2008 at 11:19 pm

    #865456

  • RE: What order do you do maintenance tasks in?

    GilaMonster (8/30/2008)

    balbirsinghsodhi (8/29/2008)

    You can put a shrinking log file as your maintenance plan but never put shrinking database in your maintenance plan.

    It's strongly recommended that neither logs nor data files...

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

    August 30, 2008 at 9:20 pm

    #865444

  • RE: Restore with no backup

    Lowell (8/29/2008)

    when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if 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)

    August 30, 2008 at 9:16 pm

    #865443

  • RE: Xquery

    Heh... still haven't put that link in your signature line, eh Barry? 😛

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

    August 30, 2008 at 9:11 pm

    #865442

  • RE: Using UNION ALL with ORDER BY NEWID()

    The Order BY you have affects the WHOLE query, UNION and all... you need to trick the 2nd query into a standalone query even in the presence of the UNION...

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

    August 30, 2008 at 9:05 pm

    #865440

  • RE: Cursor

    simon phoenix (8/30/2008)

    Now only job is to trap the begining and end of those distinct sequence and i think i can do it.

    Missed that... sorry. Easy to...

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

    August 30, 2008 at 8:50 pm

    #865439

  • RE: Cursor

    simon phoenix (8/30/2008)

    Hi

    Rog

    You are the SQl Guru, Thanks a lot , i really appreciat it, it was just bugging my head since last week. Now only job is to trap...

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

    August 30, 2008 at 8:30 pm

    #865436

  • RE: Cursor

    Heh... ok... my turn. 🙂 And sorry it took me so long to get to this problem...

    First, in order to be fast and short, this fun problem does ...

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

    August 30, 2008 at 8:27 pm

    #865435

  • RE: Cursor

    Sorry... My bad... Roger's too. That syntax, starting at ROWS, isn't part of T-SQL in SQL Server 2005.

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

    August 30, 2008 at 7:25 pm

    #865432

  • RE: more than one query in CASE-WHEN-THEN statement

    What do you get when you do the following, Gan?

    [font="Courier New"]DECLARE @SomeNumber INT

    SELECT @SomeNumber = Number

    FROM Master.dbo.spt_Values

    SELECT @SomeNumber[/font]

    How many rows were processed? If...

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

    August 30, 2008 at 5:47 pm

    #865424

  • RE: Understanding Index defragmentation

    You're talking about "defrag" and then you say "rebuild". Which is it that you are doing?

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

    August 30, 2008 at 5:22 pm

    #865420

Viewing 15 posts - 48,526 through 48,540 (of 59,102 total)