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...
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}...
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...
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 =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.