Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    I was about leaving a party-note since Steve's out until the 29th (got a out-of-office reply for a reported thread).

    But given the latest news I don't think it's appropriate...

    I wish...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 22, 2010 at 10:40 am

    #1253880

  • RE: fine tune query

    Looks like a catch-all query issue.

    See Gails blog[/url] for details.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 22, 2010 at 10:30 am

    #1253871

  • RE: Time Intervals

    I'd use a TallyTable based method:

    DECLARE @day DATETIME, @interval INT

    SET @interval = 15

    SET @day = '2010-11-22'

    ;

    WITH splitTimes AS

    (

    SELECT DATEADD(MINUTE, @interval * (N-1), @day) splitTime

    FROM Tally

    WHERE N<=(24*60/@interval)

    )

    SELECT

    agent.Agent,

    cast(sp.splitTime...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 22, 2010 at 10:01 am

    #1253853

  • RE: Job Schedule

    wannalearn (11/22/2010)

    the status is failed..

    hmm.. let me quote from my previous post:

    ...if failed, what message?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 22, 2010 at 8:43 am

    #1253801

  • RE: Calculate dates an individual lives in apartement each month

    Is this your actual table design? :pinch:

    You should really consider to normalize your table structure.

    You'd need separate tables for Persons, Buildings and BuildingsOccupied.

    Based on that, the query becomes rather simple.

    Regarding...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 21, 2010 at 3:23 pm

    #1253530

  • RE: Concatenate Data with a twist

    How about adding a comma after the [TYPE] column?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 21, 2010 at 3:13 pm

    #1253528

  • RE: Concatenate Data with a twist

    Sounds like FOR XML PATH is the way to go:

    SELECT

    DATE,

    STUFF((SELECT '|' + Symbol FROM #test t2 WHERE t2.date = t1.date AND UpDown = 1 ORDER BY symbol FOR XML PATH('')),1,1,'')

    FROM...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 21, 2010 at 2:33 pm

    #1253522

  • RE: try - catch --- doesn't work well --- Please help !!!

    Do have a TRY ... CATCH block inside your sproc [myprocedure], that would print any error message?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 21, 2010 at 5:03 am

    #1253482

  • RE: try - catch --- doesn't work well --- Please help !!!

    Please post the code and your expected result/output.

    And please explain what you mean by "each and every error".


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 21, 2010 at 3:36 am

    #1253473

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (11/20/2010)

    ...

    All this gibbering and jabbering about age -- Your are all youngsters.

    I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff Moden once said...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 20, 2010 at 4:58 pm

    #1253446

  • RE: simple sp

    Sounds like homework to me...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 20, 2010 at 8:18 am

    #1253400

  • RE: Want to append to different values to a output

    Please remember: we don't know your table structure nor your business case. All we know is what you posted.

    And based on that, I don't think we can really help you.

    You...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 20, 2010 at 6:45 am

    #1253395

  • RE: Running SQL Server 2008 with Local Admin or Domain user?

    duplicate post.

    Please reply here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 20, 2010 at 6:39 am

    #1253394

  • RE: Running SQL Server 2008 with Local Admin or Domain user

    duplicate post.

    Please reply here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 20, 2010 at 6:38 am

    #1253393

  • RE: Are the posted questions getting worse?

    WayneS (11/19/2010)

    Craig Farrell (11/19/2010)

    Wayne, Lutz and I are volunteering you for Larry. Well, I am, Lutz isn't convinced your current avatar is less appropriate. 😀

    :crazy::crying::Whistling:

    Why me? :sick:

    The only avatar...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    November 19, 2010 at 5:24 pm

    #1253369

Viewing 15 posts - 2,551 through 2,565 (of 5,502 total)