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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DFC4000
-
Cursor help
You can get the message: Server: Msg 16915, Level 16, State 1, Procedure sp_TransTrigger, Line 52 A cursor with the name 'md_cursor_1' already exists. The statement has been terminated. If you don't deallocate the cursor from memory. Especially if you execute twice within the same session...- DFC4000
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Complex Query
SELECT Assoc, Proj, SUM(CASE WHEN Cat='PROD' THEN Hours ELSE 0 END) as PROD, SUM(CASE WHEN Cat='TAFW' THEN Hours ELSE 0 END) as TAFW, SUM(CASE WHEN Cat='IDLE' THEN Hours ELSE 0 END) as IDLE FROM MyTable GROUP BY Assoc, Proj Think the above should work, cannot test on this machine - Standard...- DFC4000
- Post #5
- Forum: Microsoft SQL Server: Programming
