Forum Replies Created

Viewing 15 posts - 48,016 through 48,030 (of 59,099 total)

  • RE: Query help urgent

    samsql (10/1/2008)

    jeff waiting for the reply

    how many rows are there with 3 not null values and

    how many rows are there with 4 not null values

    from column image1 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 1, 2008 at 6:18 am

    #879416

  • RE: Need help in GROUPBY

    I've answered several of your questions and provided a code solution... the least you could do is answer just one of mine... what is the purpose of this code?

    --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 1, 2008 at 6:04 am

    #879411

  • RE: Need help in GROUPBY

    bhuvnesh.dogra (9/30/2008)

    we need to show record randomly

    Heh... I already know that... but, why is it a requirement? What is it that you are trying to do? ie. ...

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

    September 30, 2008 at 11:30 pm

    #879316

  • RE: Need help in GROUPBY

    A CTE is nothing more than a "derived table" or an "inline view"... both of which are just sub-queries. If you did it the "old way" without a CTE,...

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

    September 30, 2008 at 11:16 pm

    #879313

  • RE: Query help urgent

    samsql (9/30/2008)

    jeff thkz for the reply but i dnt want this.....

    i want the count

    Yeah... You'e right. I misread your requirements. Sorry.

    If you could provide a little test 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)

    September 30, 2008 at 10:58 pm

    #879309

  • RE: Need help in GROUPBY

    This will work... without TOP or a correlated subquery to use it...

    ;WITH

    cteRandom AS

    (SELECT ROW_NUMBER() OVER (PARTITION BY Gid ORDER BY NEWID()) AS RandRow,

    ...

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

    September 30, 2008 at 10:54 pm

    #879308

  • RE: Need help in GROUPBY

    bhuvnesh.dogra (9/30/2008)

    Is it possible to use TOP in this query ....i want to use TOP

    Why?

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

    September 30, 2008 at 10:38 pm

    #879304

  • RE: Need help in GROUPBY

    Here's the corrected test code and a solution... Now, I'm curious... why don't you care which RecID you return, please?

    create table mytest

    (

    Recid int ,

    Gid varchar(2) )

    GO

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

    insert into mytest(RecID,Gid) 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)

    September 30, 2008 at 10:29 pm

    #879302

  • RE: Need help in GROUPBY

    The test code produces errors.

    The way to do this is to use MIN and GROUP BY.

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

    September 30, 2008 at 10:26 pm

    #879299

  • RE: Query help urgent

    It would really be helpful if, in the future, you would pose such questions with a properly formed create table statement and some ready to use data. Please 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)

    September 30, 2008 at 10:22 pm

    #879298

  • RE: Select *

    Vincent Central (9/30/2008)

    I have some novice developers with big egos but small ears... We have some tables that are multi-million records and some of our developers, despite being told not...

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

    September 30, 2008 at 9:27 pm

    #879286

  • RE: what is this???

    mixalissen (9/30/2008)

    I am talking about the pattern::

    UPDATE t

    SET var1 = var2

    FROM someTable,(

    ...

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

    September 30, 2008 at 9:24 pm

    #879285

  • RE: Is this article correct? Temp Tables vs. Table Variables in SQL Server 2005

    Heh... I find it very difficult to believe an article on performance where the author says "At first, we prepare a test table with 1 million records:" and then builds...

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

    September 30, 2008 at 9:21 pm

    #879284

  • RE: Converting large Column into Rows

    John, the article that Richard was referring to (thank you for the kudo, Richard) is located at the following URL...

    [font="Arial Black"]The "Numbers" or "Tally" Table: What it is and how...

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

    September 30, 2008 at 9:07 pm

    #879283

  • RE: Converting large Column into Rows

    Well done, Richard! 🙂

    Just a suggestion... you may be able to get a wee bit more speed out of it if you eliminate as many of the math functions 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)

    September 30, 2008 at 9:04 pm

    #879282

Viewing 15 posts - 48,016 through 48,030 (of 59,099 total)