Forum Replies Created

Viewing 15 posts - 19,066 through 19,080 (of 26,484 total)

  • RE: Aging Query

    Ravi (8/24/2009)


    Lynn thanks for your feedback, form next time i will make sure i put all the problems /req. in the first post.

    i have attached the same query that...

  • RE: Twenty tips to write a good stored procedure

    arup_kc (8/24/2009)


    As an example, the cursor/temp table issue. In several SP's I have replaced the cursor with a combination of temaptable+while and it gave me better performance.

    Unfortunately, in this case,...

  • RE: Aging Query

    Ravi (8/24/2009)


    Thanks Lynn,

    Query works if i have 1 negative value in that list for the Particluar Item,City, Street like

    Date: 07/07/2009, Item : A City : NY , Street :...

  • RE: Validating Contiguous recs

    trudye10 (8/22/2009)


    Thanx to all of you for all your help, patience and guidance. I have managed to get the query completed.

    Thanx again,

    Trudye

    Trudye,

    Glad to hear that you managed to complete...

  • RE: Are the posted questions getting worse?

    GilaMonster (8/22/2009)


    Lynn Pettis (8/22/2009)


    Lynn tries to work with everyone. 😉

    Aren't there a few that have made even your personal black-list?

    You are right, to a point. But it seems...

  • RE: Problem with a simple update query - Update value in row from value in previous identical row

    conmcgarry (8/22/2009)


    Thanks I will look into that.

    But then I was wondering, if somebody were to enter an incorrect e-mail address initially, this would insert the incorrect e-mail address into...

  • RE: Are the posted questions getting worse?

    GilaMonster (8/22/2009)


    Lynn answers people that I won't. I answer people that Jeff won't. Jeff answers ones that I won't, etc.

    lol... Actually expected something more like this: I answer people...

  • RE: Are the posted questions getting worse?

    I don't think such a list should be posted. I'm not going to tell anyone who they should or shouldn't help. If you (speaking plural here) choose not...

  • RE: Did Oracle buy MySQL by accident?

    gnuoytr (8/21/2009)


    Umm. This thread is about Oracle and MySql. Whether such a thread should be on SQLServer dedicated site is not my call.

    Actually, this thread is a discussion...

  • RE: Validating Contiguous recs

    Bob did a good job describing what we need above. Please follow his lead and build us the better mouse trip to show us your problem and what you...

  • RE: Rewrite T-SQL to remove MAX function

    DBASkippack (8/21/2009)


    I inherited this SQL. I'm wrapping up a DTS to SSIS 2008 conversion for approx 50 pkg's (just about done).. all dynamic in nature (XML config to get into...

  • RE: Are the posted questions getting worse?

    We'll have to wait and see. Future posts may (or may not) prove otherwise. Of cousre if he continues like he has I'd be surprised to see many...

  • RE: Are the posted questions getting worse?

    Bob Hovious (8/21/2009)


    I just read the "jibber jabber" comment. It was over-the-top offensive, followed by smugness about his rudeness "working." I can't express my sentiments...

  • RE: Rewrite T-SQL to remove MAX function

    DBASkippack (8/21/2009)


    ahhh.. the Bill O'Reilly approach worked.. Thanks for the feedback..

    By the way, the insult had nothing to do with your getting any of the ideas that followed, that was...

  • RE: Rewrite T-SQL to remove MAX function

    Yes, that could work. Use SSIS to pull the data from Sybase to staging tables (temp tables) on SQL Server and then do the work directly from those tables....

Viewing 15 posts - 19,066 through 19,080 (of 26,484 total)