Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our PP (Def Revenue) scripts. All of our scripts for Dynamics GP can be found here
PP (Def Revenue) Scripts
 
No records to display.
NaomiP
4Penny.net
Points: 7700

3/16/2022 4:27:00 PM

STRING_AGG SQL 2017 (14) or later

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

New SQL features are hard to use because it's years before I get customers that have the new version of SQL

But this feature came out in SQL 2017, and it's becoming available.

 

STRING_AGG will turn this

Into this

 

4Penny.net
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
3