Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Points: 10450

4/28/2017 4:16:44 PM

Suppress the results of a stored procedure

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Today I need to call an existing stored procedure that inserts a line into a table. This proc always returns the RowID of the inserted line. 

In the place where I'm calling it I can't have that result set, so I need to suppress it. 

Had to search to find the answer, I'll blog it here so I don't lose it again.
Version: All
Section: SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables