Forum Replies Created

Viewing 15 posts - 33,151 through 33,165 (of 59,099 total)

  • RE: Date period from 00:00 to 23:59

    CELKO (7/23/2011)

    >> I need the data to be based on the previous week Monday to Sunday. <<

    Create a report period table and join to it.

    CREATE TABLE ReportTimeslots

    (range_name CHAR(18) NOT NULL...

    --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 23, 2011 at 1:48 pm

    #1357455

  • RE: The Market

    Having conducted many interviews over time, I've found that people frequently misclassify themselves. I know many Developers (for example) that think they're Level 5 Client/Server Developers who should be...

    --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 23, 2011 at 1:39 pm

    #1357454

  • RE: At the end of my rope!

    MuchLearnSoLittleTime (7/22/2011)

    Next step is either the noose or the food kitchen. I am getting this error in reporting services when trying to connect to my reporting server. The configuration manager...

    --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 23, 2011 at 1:16 pm

    #1357450

  • RE: Data compression in a field - is it possible?

    Is it actually necesary to keep the data "online"? Or, can you get away with "offline but available"?

    SQL Server can load information into a work table very, very quickly...

    --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 23, 2011 at 1:13 pm

    #1357449

  • RE: Caclulate Distance

    gracebite (7/22/2011)

    Hi,

    how to [font="Arial Black"]calculate distance (in meters/KMs) between 2 lat/long [/font]as Cartesian product in 2 tables

    Thanks

    Grace

    Actually, if you Google'd/Yahoo'd what I've highlighted in your original question above, you'd...

    --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 23, 2011 at 1:06 pm

    #1357448

  • RE: Merging Two Queries

    If possible not by stored procedure.

    Why not? Hopefully, you're not making the mistake of using embedded code in a GUI or SSIS or...

    I'm not sure why you'd do such...

    --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 23, 2011 at 12:57 pm

    #1357445

  • RE: Server Health Check

    tt-615680 (7/23/2011)

    Hi All,

    We are having a yearly mains supply check, therefore I would need to check for the availability and the health of the SQL Server. I would like 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)

    July 23, 2011 at 12:46 pm

    #1357444

  • RE: Urgent: Handling [& , ' etc] in TSQL

    Encapsulating the entire path (drive, path, filename) in double quotes should do the trick.

    --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 23, 2011 at 12:38 pm

    #1357442

  • RE: selecting dataset with row numbers

    opc.three (7/22/2011)

    I did some quick testing and inserting 400,000 rows into the table variable was about 20% faster that inserting the same rows into a traditional temp table.

    Heh... you know...

    --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 23, 2011 at 12:34 pm

    #1357441

  • RE: How to Delete Right 3 Characters from a string

    Ninja's_RGR'us (7/22/2011)

    Jeff Moden (7/22/2011)

    Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.

    I would point out the obvious...

    --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 23, 2011 at 12:21 pm

    #1357440

  • RE: Recursion in T-SQL

    @rockstar283,

    According to the links SwePeso provided, you already received an answer a half hour after you posted. It would be the right thing to do if you let people...

    --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 23, 2011 at 10:26 am

    #1357432

  • RE: How to Delete Right 3 Characters from a string

    Gah... I've got to learn to read the rest of the posts first. Tow other folks basically said the same thing.

    --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 22, 2011 at 4:19 pm

    #1357343

  • RE: How to Delete Right 3 Characters from a string

    Sugsy (7/22/2011)

    Just for the record Kingston's suggestion works fine n'all

    Just for the record, it will also delete the wrong data if the right 3 occurs more than once in 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)

    July 22, 2011 at 4:18 pm

    #1357341

  • RE: Recursion in T-SQL

    Take a look at the first link in my signature line below and post some readily consumable data THAT way, someone will likely jump on this right away.

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

    July 22, 2011 at 4:03 pm

    #1357335

  • RE: Copy from a folder to an other

    opc.three (7/22/2011)

    ... surely you're not going so far as to condone the use of xp_CmdShell within a trigger to copy files...or are you :ermm:

    Oh, hell NO! 😀 I frequently...

    --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 22, 2011 at 8:58 am

    #1357103

Viewing 15 posts - 33,151 through 33,165 (of 59,099 total)