Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. awhitney

    SQL Debugger executes blank rows.

    I am trying to use the Transact-SQL Debugger. I went to Object Browser, found my stored procedure, right clicked and chosed "Debug". The "Debug Procedure" window came up. I clicked on the Execute button. All of the "step" buttons are available. However, when I step-into the stored...
  2. awhitney

    Subtotaling a formula with an embedded Sum function

    I am using version 8.5 and one of the sub reports is a crosstab. Unfortunately, the users want these totals outside of the crosstab.
  3. awhitney

    Subtotaling a formula with an embedded Sum function

    Help!!!! I am working on a timesheet report that totals the number of hours per day based on various time entry activities. I need to calculate comp time hours based on if the sum of the daily hours total more than 8. My formula is as follows: if Sum ({@CheckRegHours}...
  4. awhitney

    Cursor problems

    Thanks for responding John, You asked: "What do you mean "the script stops?" Is an error generated? If so, what is it? How many rows are returned from the cursor's SELECT?" No error...all I see is: Cursor created Cursor opened Then it just sits there with no rows returned. I think I need a...
  5. awhitney

    Cursor problems

    I'm new a creating stored procedures and using cursors. For some reason, my cursor does not work. Here is the problem area. ... DECLARE cPersonnel CURSOR FAST_FORWARD FOR SELECT personnel_key, login_name, failed_attempts, office_key FROM Personnel WHERE (disabled = 'N') set @msg =...
  6. awhitney

    Text Form Field Properties problem

    I am working on a form with 7 text fields. The first 3 are along the top of the form and are pretty generic (text only, no multiple lines, no scroll, with rich text formatting and spell checker). The 4th field is a narrative field (multiple lines, rich text formatting with spell checker). The...

Part and Inventory Search

Back
Top