Forum Replies Created

Viewing 15 posts - 53,671 through 53,685 (of 59,089 total)

  • RE: Table Design for Real World App

    TBIG,

    What you're describing is an "Audit Process" or "Audit Trail"... there are many ways to do this including Audit Triggers that save "old data" to an Audit table when 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)

    December 9, 2007 at 8:47 am

    #758378

  • RE: Further learning in SQL

    You're currently looking at one of the best resources there is for learning... SQLServerCentral.com. Everyday, I look at as many posts as I can... Some folks have some really...

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

    December 9, 2007 at 8:42 am

    #758376

  • RE: Delay in executing a query from VB

    That's probably because when you execute it from VB, you're doing it as embedded SQL... which has no chance of reusing an Execution Plan.

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

    December 9, 2007 at 8:21 am

    #758374

  • RE: copy paste in sql

    No...

    But you can write forumulas in the Excel spreadsheet that will create the necessary INSERT/SELECT or INSERT/VALUES statements.

    There's also several ways to import the data from a spreadsheet into SQL...

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

    December 9, 2007 at 8:19 am

    #758373

  • RE: Disk Sace Usage

    What are you running the code from? Query Analyzer or ???

    The code, as I've posted it, runs fine...

    Is it possible that you've run into the same problem a lot...

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

    December 9, 2007 at 7:47 am

    #758372

  • RE: Calculating Task Past Due Dates without weekends

    kenny (12/8/2007)

    Wow, this is the fastest response I have ever gotten.

    Thanks Jeff for your assistance.

    Just lucky... I happened to be "in the neigborhood" and just happened to have an answer...

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

    December 9, 2007 at 7:43 am

    #758371

  • RE: Cross Tab Query

    Jeremy,

    Do you have an example of how you'd solve the above using the Pivot operator?

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

    December 9, 2007 at 7:29 am

    #758370

  • RE: Question

    You bet, Cali... thanks for the feedback.

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

    December 9, 2007 at 7:22 am

    #758369

  • RE: Calculating Task Past Due Dates without weekends

    I wish I could take the credit for the following bit of SQL prestidigitation, but I can't... thank "Sergiy" 😉

    CREATE FUNCTION dbo.fnAddWeekdays (@Start DATETIME, @Days INT)

    RETURNS DATETIME

    ...

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

    December 8, 2007 at 7:01 pm

    #758345

  • RE: Disk Sace Usage

    Ah, crud... I just noticed that this is a 2k5 forum... the code I posted is most definitely for 2k...

    You'll need to do some mods to the code but I...

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

    December 8, 2007 at 6:59 pm

    #758344

  • RE: Disk Sace Usage

    I guess the best way to help you get this sorted out, is to give you a chunk of "tool" code I made a while back... could easily be turned...

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

    December 8, 2007 at 6:26 pm

    #758340

  • RE: Disk Sace Usage

    In your code, you never say...

    DELCLARE @db_Name SYSNAME

    That means you have an undefined variable and it's gonna give you an error. Here's the beginning of your code... and there'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)

    December 8, 2007 at 6:13 pm

    #758339

  • RE: Creating reports with Tsql

    fosco (12/8/2007)

    Thanks for the replies, we have an application that actually creates the reports in pdf format, but the data is on sql server 2000 standard backend, when the application...

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

    December 8, 2007 at 6:00 pm

    #758338

  • RE: Identify letter vs. number

    This takes care of the single letter and blank situations...

    --===== This is the solution for the known constraints on the data as posted

    DECLARE @MaxWidth TINYINT

    SET @MaxWidth...

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

    December 8, 2007 at 5:55 pm

    #758336

  • RE: Identify letter vs. number

    Drat... both of ours come up with a little problem when we have data like this...

    --===== This just creates demonstrable test data and is NOT part of the solution

    SET NOCOUNT...

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

    December 8, 2007 at 5:15 pm

    #758335

Viewing 15 posts - 53,671 through 53,685 (of 59,089 total)