Forum Replies Created

Viewing 15 posts - 12,331 through 12,345 (of 59,099 total)

  • RE: Export data in XML to import into Word

    Matt Simmons - Tuesday, May 2, 2017 2:31 PM

    Kev,  Why not connect directly to SQL via Word as several others 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 17, 2018 at 8:03 am

    #1990835

  • RE: Query taking more time

    ChrisM@Work - Thursday, May 17, 2018 2:15 AM

    haichells - Wednesday, May 16, 2018 10:31 PM

    --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, 2018 at 7:57 am

    #1990834

  • RE: Cannot Open Database "xxx" requested by login. Login failed

    clearlymichele - Wednesday, May 16, 2018 2:16 PM

    Antares686 - Wednesday, March 28, 2007 10:06 AM

    --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 16, 2018 at 6:35 pm

    #1990752

  • RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

    Beatrix Kiddo - Wednesday, May 16, 2018 9:22 AM

    Agreed. Also I would HATE to get an insincere card or email from...

    --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 16, 2018 at 6:30 pm

    #1990751

  • RE: Where Waits coming from?

    Yuri55 - Wednesday, May 16, 2018 10:18 AM

    Thanks Jeff- will double check with Dev team. Good to know about your real life...

    --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 16, 2018 at 10:40 am

    #1990712

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    andrew gothard - Wednesday, May 16, 2018 9:44 AM

    Jeff Moden - Wednesday, April 25, 2018 4:17 PM

    --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 16, 2018 at 10:11 am

    #1990708

  • RE: Creating Filters like Previous Week, from Tuesday to Monday

    kyagi.jo - Wednesday, May 16, 2018 8:45 AM

    I was using SET STATISTICS IO ON, along with reading through the query plan in...

    --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 16, 2018 at 10:01 am

    #1990704

  • RE: SQL server 2014 profiler bottom pane not displaying trace -- please help...

    jellybean - Wednesday, May 16, 2018 6:34 AM

    Hi,

        I hipe I'm posting in the correct forum. Apologies if I'm not...I using...

    --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 16, 2018 at 8:28 am

    #1990672

  • RE: Creating Filters like Previous Week, from Tuesday to Monday

    kyagi.jo - Wednesday, May 16, 2018 8:16 AM

    Thanks, the simplified way of calculating the date range produced a much faster query plan than...

    --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 16, 2018 at 8:25 am

    #1990671

  • RE: Query taking more time

    haichells - Wednesday, May 16, 2018 6:50 AM

    Dear All,

    I have a table and it just have 34K rows in it. I 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 16, 2018 at 8:19 am

    #1990669

  • RE: Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis

    ThomasRushton - Wednesday, May 16, 2018 6:54 AM

    sunilchand - Wednesday, May 16, 2018 3:54 AM

    --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 16, 2018 at 8:01 am

    #1990664

  • RE: DeadLock --trying to figure out what resource-list is telling me?

    456789psw - Wednesday, May 16, 2018 7:17 AM

    Solved!

    <SyncPoint> is an indication of an Exchange event. If you run profiler trace...

    --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 16, 2018 at 7:58 am

    #1990662

  • RE: Performance Question

    Budd - Wednesday, May 16, 2018 7:35 AM

    Hi,
    I have much more to learn than to teach, but I have a habit of...

    --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 16, 2018 at 7:55 am

    #1990661

  • RE: Creating Filters like Previous Week, from Tuesday to Monday

    kyagi.jo - Wednesday, May 16, 2018 3:49 AM

    Hi,

    If I needed to create some kind of filter that would get the data between...

    --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 16, 2018 at 5:33 am

    #1990632

  • RE: Where Waits coming from?

    Yuri55 - Tuesday, May 15, 2018 6:24 PM