Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Order of things

    Um... I was hoping for a generic answer. However, here are the two stored procedures, Old and New. I can't get the Estimated Execution Plan to return anything useful, it simply...

    July 25, 2007 at 9:47 am

    #722352

  • RE: Query Assistance

    It's Latvian. I can never remember what it means, but I always tell everybody "sewage: I don't even want to know what...

    June 1, 2007 at 2:33 pm

    #710426

  • RE: Removing duplicates while counting records

    The only thing I've been able to come up with is this, but I imagine there's a better way. Plus, I'm not absolutely certain this is what you want.

    May 24, 2007 at 12:03 pm

    #708742

  • RE: Query Assistance

    OMG! You're a genius! That worked perfectly! Thank you soo much.

    em

    May 24, 2007 at 9:17 am

    #708685

  • RE: varchar length

    BooYah! You're the best! It was a trigger to the Patient_History table; we had forgotten to change the length of that UniqueCode field.
     
    Thank you soo much!
     
    em

    September 27, 2006 at 8:54 am

    #662747

  • RE: varchar length

    Michael, I always run SQL statements, so everything I've done has been that way. This field, however, was changed from 20 to 125 with the Enterprise Manager; and then I...

    September 27, 2006 at 8:13 am

    #662726

  • RE: Line Termination

    Thank you, that article was perfect.
     
    em

    September 27, 2006 at 7:32 am

    #662707

  • RE: Bonehead moves?

    I just forgot my first WHERE clause today! I was helping a co-worker fix a problem that a customer had complained about....

    September 25, 2006 at 3:05 pm

    #662372

  • RE: Insert taking too long

    Ok, I'm confused by the Profiler. I can get it to show me that things are being locked, but I can't figure out how to get it to tell me...

    September 22, 2006 at 9:04 am

    #662005

  • RE: Query Assistance

    I'm not sure you would say he has direct access to the Production Tables; he deleted the duplicates through the application that sits on top of the database.
     
    We don't...

    September 20, 2006 at 1:22 pm

    #661578

  • RE: Query Assistance

    Thank you very much for your help. I did what you said with the working table, and that seemed to work ok. It turns out there was an extra complication,...

    September 20, 2006 at 6:57 am

    #661474

  • RE: Query Assistance

    Thank you so much for your help!
     
    Here's what happened, and what I'm doing. We wrote a script that inserted several default Steps for given Tasks. Then, when the user selected these...

    September 11, 2006 at 7:03 am

    #659609

  • RE: Beginning Administration

    I'm only a beginner myself, but I think you would want to set this up with a Job rather than with a Trigger. Make a stored procedure that does what...

    September 1, 2006 at 7:12 am

    #658017

Viewing 13 posts - 1 through 13 (of 13 total)