Forum Replies Created

Viewing 15 posts - 29,926 through 29,940 (of 59,101 total)

  • RE: Importing Multiple csv files into one SQL Table

    Quick little tip for finding file names in a known directory without using xp_CmdShell...

    EXEC xp_Dirtree 'folderpath',1,1

    The first "1" says "for this level only" and the second "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)

    May 18, 2012 at 7:46 am

    #1489690

  • RE: SSIS - File Watcher Task

    Any idea when the first one is coming out, Orlando?

    --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 18, 2012 at 7:38 am

    #1489684

  • RE: Generating n-Tuples with SQL

    dwain.c (5/17/2012)

    The above debate between Jeff and Paul...

    I'm not looking at it as a debate. It's just the normal kind of discussion two wireheads have about different things. 🙂

    Shifting...

    --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 18, 2012 at 7:17 am

    #1489665

  • RE: Generating n-Tuples with SQL

    Ok... since no one else took the testing suggestion...

    --=====================================================================================================================

    -- Test setup

    --=====================================================================================================================

    --===== Enable the auto-display of rowcounts just to get a little feedback on the test...

    --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 18, 2012 at 7:00 am

    #1489645

  • RE: List of the last day of the month

    dwain.c (5/18/2012)

    Jeff Moden (5/17/2012)

    To return precisely what you asked for...

    DECLARE @Year DATETIME;

    SELECT @Year = '2011';

    WITH

    cteDate AS

    (

    SELECT EOM = DATEADD(mm,number,@Year)-1

    FROM master.dbo.spt_values v

    WHERE...

    --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 18, 2012 at 6:26 am

    #1489608

  • RE: parse string

    Eugene Elutin (5/18/2012)

    Jeff Moden (5/16/2012)

    You know me... I don't go into these things blind. I always have test data. Helps me keep my alligator mouth from overloading my...

    --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 18, 2012 at 6:09 am

    #1489596

  • RE: Generating n-Tuples with SQL

    Not so sure about that. I've beat the rCTE for this problem for CPU and absolutely smoked it for reads just by doing the "simple" conversion to a While...

    --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, 2012 at 11:15 pm

    #1489477

  • RE: This forum vs. Ask SSC

    Thomas Stringer (5/16/2012)

    I tried searching for some explanation before posting, but I found nothing close to what I'd like to know. Ask SSC seems to be a board-type question...

    --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, 2012 at 10:37 pm

    #1489470

  • RE: Do Interviews Work?

    Considering how bad the candidates have been lately, I believe I'm going to change my first question to "So tell me! Do you like porkchops punk? Well, 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)

    May 17, 2012 at 10:30 pm

    #1489468

  • RE: List of the last day of the month

    Jay Pete (5/17/2012)

    Hi Guys,

    How can i make list of the last day of each month of the year 2011?

    Output:

    January-2011 :- 31-January-2011 Monday

    February-2011:- 28-February-2011 Monday

    March-2011:- 31-March-2011 Thursday

    April-2011:- 30-April-2011 Saturday

    May-2011:- 31-May-2011 Tuesday

    June-2011:-...

    --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, 2012 at 10:10 pm

    #1489465

  • RE: Summing in a table

    Sachin 80451 (5/17/2012)

    I need to work out the percentage of the values from sales. I have split my data into the necessary group like:

    status ...

    --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, 2012 at 9:47 pm

    #1489462

  • RE: Select all days that are the last day of the month from a calendar table

    Just a sidebar... when I make a calendar table, I generally have 2 date columns. "Today" and "Tomorrow". It not only helps more easily group data by day,...

    --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, 2012 at 9:35 pm

    #1489458

  • RE: Generating n-Tuples with SQL

    Crud. It's not my day. I have to be honest even if it's not going to look so good for me. :blush: I don't know if 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)

    May 17, 2012 at 8:30 pm

    #1489450

  • RE: Setting the Identity in a temp table using a variable

    Eugene Elutin (5/17/2012)

    Don't use identity, use ROW_NUMBER() instead. You can start counting from any requested value...

    Seconded...

    --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, 2012 at 3:51 pm

    #1489397

  • RE: What is Big Data?

    CrankyRat (5/16/2012)

    "Relational database technology is pretty much obsolete and archaic.", Geoffrey P. Malafsky, Ph.D. from the Karen Lopez link.

    What an idiot.

    I'm really happy to see someone else thought those exact...

    --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, 2012 at 3:27 pm

    #1489391

Viewing 15 posts - 29,926 through 29,940 (of 59,101 total)