Forum Replies Created

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

  • RE: Trying to join to xp_fileexist

    Crud... I was hoping they were unique so we could use xp_Dirtree to solve your problem very easily. xp_FileExists is not available in SQL Server 2k8 like it is...

    --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 9:38 am

    #879572

  • RE: Calculating and allocating serial numbers

    I agree... if the VB code works and there is no impact on performance, there's no reason to change horses right now.

    --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 7:02 am

    #879442

  • RE: Need help in GROUPBY

    Thanks. Oh, and the randomness comes from the fact that NEWID generates random numbers. If you order by a random number like that, the result will be 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)

    October 1, 2008 at 6:57 am

    #879439

  • 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

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