Forum Replies Created

Viewing 15 posts - 34,771 through 34,785 (of 59,102 total)

  • RE: question about update record

    Mike01 (3/6/2011)

    don't forget the where clause or all of your records will be the same 😉

    Thanks for the catch, Mike. Shamefully, I only fixed what I saw. :blush:

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

    March 7, 2011 at 6:16 am

    #1295283

  • RE: Concatenating Rows

    guruprasat85 (3/7/2011)

    Declare @var varchar(1000)

    Set @var=''

    Select @var = @var + fruit + ',' from #temp

    Select substring(@var,1,len(@var)-1)

    Please read the posts above for why that's a bad idea and what to do about...

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

    March 7, 2011 at 6:14 am

    #1295280

  • RE: how to write this query

    Mad-Dog (3/6/2011)

    Hi,

    I've 2 server with the same tables and i need to move data between the DEV to the PROD.

    my question is how i can write the tsql that will...

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

    March 6, 2011 at 1:19 pm

    #1295151

  • RE: Is Microsoft neglecting SMO?

    Phil Factor (3/6/2011)

    Maybe we should turn it around and list all the things that they spend way too much time and effort on, Jeff.

    Good idea, Phil, except that list...

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

    March 6, 2011 at 1:16 pm

    #1295149

  • RE: Execute stored procedure

    Deepthy (3/6/2011)

    Hi all,

    I want to execute the stored procedure usp_myproc(@versionid int,@stationname@ varchar(100),@enddate date,@reason varchar(100)) by passing 200 different values of @versionid and @stationname while the @enddate and 'reason are always...

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

    March 6, 2011 at 12:58 pm

    #1295145

  • RE: question about update record

    update Info set header=ISNULL(@hea,header),content=ISNULL(@cont,content),image=(@im,image)

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

    March 6, 2011 at 12:56 pm

    #1295144

  • RE: SQL Query - Query for various attributes problem ...

    bdaviduck (3/6/2011)

    Yes -- as a programmer, it was natural to think of a solution using bitmasks; and it actually works fairly well on SQL server -- however, I am open...

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

    March 6, 2011 at 12:50 pm

    #1295142

  • RE: Concatenating Rows

    Robert Bourdeau (3/4/2011)

    It is a shame that TSQL lacks the CONNECT BY clause that is available with Oracle. All these complex solutions could be eliminated for many classes of row-joining...

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

    March 6, 2011 at 11:54 am

    #1295139

  • RE: Concatenating Rows

    Jeff Moden (10/18/2009)

    And here's a function for items that don't exceed 8K...

    --===== Create a function that uses VARCHAR(8000) with a DUPE Eliminator

    CREATE FUNCTION dbo.Concat8KTestDupElim

    ...

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

    March 6, 2011 at 11:51 am

    #1295138

  • RE: Concatenating Rows

    Carlo Romagnano (10/17/2009)

    msam77-503326 (10/15/2009)

    Below is simple sql that does that

    declare @res varchar(Max)

    select @res = coalesce(@res + ',', '') + [name]

    from

    (

    select 'Apple'...

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

    March 6, 2011 at 11:49 am

    #1295136

  • RE: Concatenating Rows

    burtsev (3/4/2011)

    bnordberg (10/14/2009)

    I recently had to concatenate ~1.5 billion rows of text (average length of 110 characters). These were medical notes where each line was a sepearte row. I tested...

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

    March 6, 2011 at 11:47 am

    #1295134

  • RE: Concatenating Rows

    kaplan.dani (3/4/2011)

    I think this (using a cursor to iterate on the list) is the most reasonable solution for the newbie sql dveloper.

    Is there a performance issue in this way ?

    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)

    March 6, 2011 at 11:42 am

    #1295132

  • RE: Concatenating Rows

    RHaverty 8478 (3/4/2011)

    My solution where I posted the coalesce solution will eat up a cursor on performance. Another better solution than using a cursor is:

    But, it's not. It...

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

    March 6, 2011 at 11:39 am

    #1295131

  • RE: Concatenating Rows

    vkhabas (3/4/2011)

    Sorry Guys, as I remember the CTE recursion works with depth <= 70

    Actually, the default for the number of resursions is 100. The max explicit size is a...

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

    March 6, 2011 at 11:37 am

    #1295130

  • RE: Concatenating Rows

    a.rajmane (3/6/2011)

    Another simple way of doing this ... see the example at http://www.sqlsuperfast.com/post/2011/02/17/T-SQL-to-Convert-rows-into-single-column.aspx

    You had a bad link in your post. I fixed it in the above quote.

    Both of those...

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

    March 6, 2011 at 11:34 am

    #1295129

Viewing 15 posts - 34,771 through 34,785 (of 59,102 total)