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
lcarness 11/19/2018 5:59:58 PM

Add SQL DB name to a GP Query

Does anyone have code that will help me add the 5 char DB name to all of the results of a Query of GP tables. 

If I query the CMPANYID from  SY00100 I get 1, then I go to Dyanmics  SY01500 and I look up 1 and I can get the long Company Name. But then I have no common fields to join the name to any other selected items.  Even if it worked, all I really want is the 5 Digit Database Name. 

Any help would be appreciated. 


Thank you



Version: GP 2013
Section: Dynamics GP, SQL for Beginners, 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