Forum Replies Created

Viewing 15 posts - 58,726 through 58,740 (of 59,067 total)

  • RE: Calling external code

    Jon,

    What kind of VB functionality are you looking to 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)

    July 9, 2005 at 9:18 am

    #572700

  • RE: Sequential numbered column

    IF OBJECT_ID('TempDB..#Results') IS NOT NULL

    DROP TABLE #Results

    SELECT IDENTITY(INT,1,1) AS RowNum,

      ...other columns as you need...

    INTO #Results

    FROM ...your tables and joins...

    ORDER BY ...the order 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)

    July 7, 2005 at 8:18 pm

    #572146

  • RE: Doubt on Temporary tables

    You CAN get an estimated execution plan when you use temp tables by first executing just the code that makes the temp tables and then doing the execution plan.  If...

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

    July 7, 2005 at 7:51 pm

    #572140

  • RE: Printing Reports

    Pretty sharp, Womalley... sometimes ya gotta do what ya gotta 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)

    July 7, 2005 at 7:45 pm

    #572138

  • RE: How to move text file in Stored Prcoedure

    The use of xp_CmdShell is considered to be a security risk by most DBA's and, I believe, the default is you must have"SA" (not just "dbo" rights to use it.  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)

    June 25, 2005 at 8:31 am

    #568454

  • RE: Recusive Hierachy

    rschaeferhig,

    You were quite right... you didn't change much.  In fact, when I built a test Directory and Employees table and inserted the records you showed in a previous...

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

    June 7, 2005 at 10:02 pm

    #563726

  • RE: Recusive Hierachy

    Obviously, the code I posted had to be changed to accomodate your particular requirements.  You are correct... something went drastically wrong.  If you could post the schema of your personnel...

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

    June 6, 2005 at 9:21 pm

    #563380

  • RE: Recusive Hierachy

    Sure... with examples... I used temp tables for the example so I don't clutter up my hard drive... you don't have to (in fact, I recommend that you don't)...

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

    June 3, 2005 at 6:28 pm

    #563039

  • RE: Can this be done without using cursor?

    Bull2000,

    If you use the concatenate method using the TAB character (CHAR(9) in code) instead of a comma as a delimiter, the output might just cut&paste into Excel with no other...

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

    May 26, 2005 at 7:02 am

    #561195

  • RE: Date Conversion

    Cory...

    This works the way you want... leading zeros and mm/dd/yyyy format intact...

    DECLARE @Date VARCHAR(30)

    SET @Date = '2/3/2005'

    SELECT CONVERT(VARCHAR(10),CONVERT(DATETIME,@Date),101)

              

    ----------

    02/03/2005

    (1 row(s) affected)

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

    May 19, 2005 at 9:13 pm

    #560095

  • RE: question about shrinkdatabase

    The log file probably grew for a pretty good reason. If you shrink it and it decides to grow again, especially if the growth size is small or 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)

    May 17, 2005 at 12:46 am

    #559175

  • RE: Stop SQL2K Rounding

    Try this, instead...

    "select boy + REPLACE(STR(age,7,4),' ','') + ' is years old'

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

    May 15, 2005 at 10:40 am

    #558932

  • RE: Date column Auto Convert on INSERT

    If it truly is a "DateTime" column, it just doesn't matter what format you store it in so long as it is one recognized by SQL.  It will have...

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

    May 15, 2005 at 10:18 am

    #558931

  • RE: CHECK Constraint for date format required

    If it truly is a "DateTime" column, it just doesn't matter what format you store it in so long as it is one recognized by SQL.  It will have 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)

    May 15, 2005 at 10:16 am

    #558930

  • RE: How to use Left Mid Right and hex-to-dec conversion in SQL

    Not trying to be difficult here... hex doesn't normally work quite the way you described so could you post an example of the hex number and what the expected outcome...

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

    May 15, 2005 at 10:09 am

    #558929

    • Viewing 15 posts - 58,726 through 58,740 (of 59,067 total)