Forum Replies Created

Viewing 15 posts - 16 through 30 (of 42 total)

  • RE: Need help with stored procedure with cursor

    Hello Matt -

    The gridkey is a sequence key required by the application, and it is obtained from a grid sequencing table. Many keys in the application come from such...

  • RE: Need help with stored procedure with cursor

    Thanks also for this tidbit - now that I have the process working, I can play around with options and refinements!

    Really appreciate all your help.

    Kenena

  • RE: Need help with stored procedure with cursor

    Hello Jason -

    mrpolecate was able to add to the assist you gave me this morning, and I just want to say thanks so much for your time. This will...

  • RE: Need help with stored procedure with cursor

    Thanks for the help, mrpolecat. I made the suggested changes and after changing to While @@Fetch_status <> -1, it ran successfully. I can't tell you what this means...

  • RE: Need help with stored procedure with cursor

    The table TRAINING$ has only 60 rows, each has an employee id identifier and they happen to be unique here.

    Thanks for your help, I appreciate it.

  • RE: Need help with stored procedure with cursor

    Hello Jason -

    I made the suggested change, but I am still getting multiple entries of the first row. Any other suggestions on that?

    Thanks,

    Kenena

  • RE: Need help with stored procedure with cursor

    Thanks, Jason.

    That would be fine in the case of this particular table, as it was added by me as allowed by the application, but the other application tables cannot be...

  • RE: Need help with stored procedure with cursor

    Hi Jason -

    Thanks for your reply. My application has a lot of these sequence tables. This SP can be used to call the next sequence from whichever table...

  • RE: Half a Million

    my apology

  • RE: CHARINDEX - CAPTURING TEXT TO LEFT

    Thanks for your help, but I am receiving the error message that data type of TEXT is invalid for the function

    The comments field is like the following:

  • RE: CHARINDEX - CAPTURING TEXT TO LEFT

    Thanks, Sergi and John -

    I'll try this with my data.

    Kenena

  • RE: DBA without system administrator privileges

    I have the same situation.  My full time job is managing and developing one relatively small asset management database.  I query for issues weekly, monthly and quarterly and they don't get...

  • RE: pull values every 15 minutes from report running in minutes

    Thanks very much to Carl, Michael and Tomm for supplying your suggestions, all of which will take some experimentation on my part to verify as I have a good learning curve...

  • RE: SubQuery Error

    In my case the trigger is there to effect MANUAL data changes - if those changes are not needed and another corrective change is, the trigger must be disabled and...

  • RE: SubQuery Error

    I have received a similar error message when trying to update a table that has a trigger.  If you have a trigger on that table, you must stop it and...

  • Viewing 15 posts - 16 through 30 (of 42 total)