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 bkrike 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: *
- Users: davidgoulet
- Content: Threads
- Order by date
-
Inserted records from cursor are doubling up
I'm are trying to insert invoice record in a table. Where the invoice has more than one line, I'm trying to write each line to a separate page in my journal table. Unfortunately page one need to be ' ', and the next page '001'.. '002', etc. I'm using an If statement to do this, but what is...- davidgoulet
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Trigger with Cursor - performance issue
I am having a performance problem using a cursor. Looking for an alternative method, that I can understand. I have two tables: 1. On order header table (opheadm) and and order detail table (opdetm). I am trying to set the delivery method on the order header tables, based on the total weight...- davidgoulet
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
