Forum Replies Created

Viewing 15 posts - 41,536 through 41,550 (of 59,102 total)

  • RE: query to modify

    Bob Hovious 24601 (10/16/2009)

    Jeff,

    I have a couple of questions:

    (1) Who are you, and (2) what have you done with Jeff Moden?

    Alternatively:

    (1) What kind of tranquilizers are 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)

    October 16, 2009 at 7:48 pm

    #1067278

  • RE: query for random data but grouped

    First, because it's such an unusual requirement, I guess I'd like to know the business reason behind this, if you don't mind. Thanks.

    Second, I have a question. What...

    --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 16, 2009 at 7:23 pm

    #1067276

  • RE: improving performance of stored procedure

    Heh... OK... cuffs don't match collar here...

    In your original post, you say you have a view and you posted...

    ALTER view [dbo].[[font="Arial Black"]vwLawsonGLAmounts_Memo[/font]] WITH SCHEMABINDING as....

    ... Then you go on 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)

    October 16, 2009 at 7:09 pm

    #1067274

  • RE: improving performance of stored procedure

    GardenLady,

    In the GLUnits table, what is the purpose of the DB_Units_13 column? What does it contain and why is it different for the following rows in the sample data?

    Company...

    --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 16, 2009 at 5:45 pm

    #1067269

  • RE: improving performance of stored procedure

    By the way, GardenLady... Nice job on the data load for #GLUnits... it loaded without error. Not sure I can help the view, but I'm looking at 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)

    October 16, 2009 at 5:24 pm

    #1067264

  • RE: improving performance of stored procedure

    One of the problems that I see in the view is that the same data is being SUMmed over and over and over. Not sure I can figure 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)

    October 16, 2009 at 5:16 pm

    #1067263

  • RE: Afraid of Help

    It's a tough call...

    First, most people don't even know they need help. That's why Microsoft put Cursors, While Loops, CLR's and other forms of RBAR in SQL Server......

    --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 16, 2009 at 4:45 pm

    #1067260

  • RE: Slow Query

    Tara-1044200 (10/16/2009)

    select distinct a.empid

    from ViewEmpployee a inner join #Empdates b on a.empid=b.empid,#researchtab

    where EmmJobCode in( '435','767','974') or

    (Job1 = '5' or Job2 = '5'or Job3 ='5' or Job4 = '5' or Job5...

    --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 16, 2009 at 2:12 pm

    #1067188

  • RE: TSQL Question about getting data

    Brad,

    This appears to be a "simple" running total problem. If you'd take the time to format the data in a readily consumable format along with a CREATE TABLE statement,...

    --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 16, 2009 at 1:53 pm

    #1067171

  • RE: date columns based query

    sql2000-915039 (10/16/2009)

    I have a datecolumn in this format 2009-10-15 16:57:00 in a table.

    I need to write a query which takes this date column values and classifies rows based on 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 16, 2009 at 1:46 pm

    #1067163

  • RE: Poor Man's Enterprise Feature - Lock Pages in Memory

    Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? 😉

    --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 16, 2009 at 1:09 pm

    #1067140

  • RE: Concatenating Rows

    sonphan11 (10/16/2009)

    This method:

    DECLARE @var varchar(8000)

    SET @var = ''

    SELECT @var = @var + FieldName + '/'

    FROM Table

    SELECT @var

    works fine for even multiple entities, just create a view first. I've been using...

    --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 16, 2009 at 12:50 pm

    #1067121

  • RE: query to modify

    I don't know folks... don't kill me for this but he is a newbie, he asked very politely, it wasn't one of those "URGENT, URGENT!!!!" requests that we frequently see,...

    --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 16, 2009 at 9:04 am

    #1066970

  • RE: Concatenating Rows

    msam77-503326 (10/15/2009)

    Below is simple sql that does that

    declare @res varchar(Max)

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

    from

    (

    select 'Apple' as...

    --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 15, 2009 at 4:14 pm

    #1066621

  • RE: Concatenating Rows

    Outstanding, Rob! I love it when a plan comes together. According to your timings, the XML beat the tar out of the CLR and the simple 8k function...

    --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 15, 2009 at 4:09 pm

    #1066619

Viewing 15 posts - 41,536 through 41,550 (of 59,102 total)