Forum Replies Created

Viewing 15 posts - 48,736 through 48,750 (of 59,099 total)

  • RE: reset sequence when value of one column changes

    Loner (8/13/2008)

    It is SQL Server 2000 so I cannot use RANK, that is why I posted the question in this forum.

    The one you posted for SQL Server 2000 worked liked...

    --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 17, 2008 at 7:00 pm

    #859222

  • RE: Arrays

    You can get by without creating the extra temp table...

    SELECT d.Name,t.N*10 AS DeciCount

    FROM (SELECT Name,COUNT(*) AS TheCount

    ...

    --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 17, 2008 at 6:53 pm

    #859220

  • RE: Selecting The Top 3 Numbers Used The Most

    Lian Pretorius (8/12/2008)

    karthikeyan (8/12/2008)

    Hey Trevor,

    I have tested the below script, It is giving perfect result.

    Same here.

    Trevor, Karthik's script above uses a temp table - Which cannot be used in view's...

    --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 17, 2008 at 6:45 pm

    #859216

  • RE: dbo

    It means "DataBase Owner" and is a server role. Lookup server roles in Books Online.

    --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 17, 2008 at 6:39 pm

    #859213

  • RE: List out SP's Columns into a Table

    sqlindia (8/12/2008)

    Hi All

    I want to list out columns name of SP into a table. They can be dynamic.

    Thank in advance

    sonny

    I'm pretty sure this can't be done reliably. Sure,...

    --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 17, 2008 at 6:38 pm

    #859212

  • RE: Creating CLR assemblies with VS 2008

    I guess I'd have to ask... what does the CLR and the C# function do?

    --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 17, 2008 at 6:17 pm

    #859208

  • RE: Beginner Question about CLR

    So far, the only place I've seen CLR's beat T-SQL is in the area of RegEx Replace...

    --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 17, 2008 at 6:10 pm

    #859206

  • RE: Risk Of Enabling CLR

    Denby (7/21/2008)

    Also, is the anything i should be monitoring from a DBA's perpective if feature is enable.

    Absolutely! First, I'd make bloody sure that the source code was in 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)

    August 17, 2008 at 6:09 pm

    #859205

  • RE: IdentityColumn is Duplicated ?

    dolly (7/30/2008)

    In my web based application Identity column is duplicated when simultaneously record are inserted by different machine

    (i think so) i will solution for handling...

    --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 17, 2008 at 6:01 pm

    #859204

  • RE: XML

    Without a whole lot more information ;), my answer would be... change it so it doesn't do that anymore. 🙂

    You might want to conscribe any XML to the VARCHAR(MAX)...

    --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 17, 2008 at 5:16 pm

    #859201

  • RE: How to use stored procedure instead of cursors?

    It's a paradigm shift... with Cursors, you think "rows"... with setbased programming, you must learn to think "columns"... as in "What do I need to do to this column for...

    --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 17, 2008 at 5:12 pm

    #859200

  • RE: Debugger For SQL

    Lemme get this straight, Carl... you think it's better for the app to write and pass data in the forum of Unioned SELECT statements than to pass a comma seperated...

    --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 17, 2008 at 5:04 pm

    #859199

  • RE: Recommendations on LinkedIn

    I'm thinking it could help employers notice me if they see who I've had forum discussions with.

    Heh... WHICH forum discussions would you be talking about? You have precisely 1...

    --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 17, 2008 at 4:20 pm

    #859197

  • RE: Can't install sql server 2005:(

    Which edition of SQL Server 2005 are you trying to install?

    --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 17, 2008 at 4:12 pm

    #859196

  • RE: Need query in SQL server 2000

    Venkatesan Prabu (8/17/2008)

    create table FirstTable(Attrib1 varchar(10), Attrib2 varchar(10),Attrib3 varchar(10))

    insert into FirstTable values('Doc1','Attrib1','val1')

    insert into FirstTable values('Doc2','Attrib2','val2')

    insert into FirstTable values('Doc3','Attrib3','val3')

    insert into FirstTable values('Doc4','Attrib4','val4')

    select * from FirstTable

    create table SecondTable(Attrib2 varchar(10),Attrib22 varchar(10))

    insert into SecondTable...

    --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 17, 2008 at 3:49 pm

    #859195

Viewing 15 posts - 48,736 through 48,750 (of 59,099 total)