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: 50375

4/26/2012 11:02:01 AM

SQL - Table Value Constructors

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

I often warn people that the article is not new or ground breaking, it's a memory aid. There are some SQL tasks that are hard for me to remember; this one is worse because I can't remember what it's called to look it up. <smiles>

At any rate, I'll post it here and put it on the SQL menu and when I need it again it'll be here.

The following example shows how to use SQL Table Value Constructors (SQL 2008 and above)

This allows you to insert a series of constants into a table. I use it a lot when building small lookup tables, I put it right after the 'Create Table' statement
Version: Unknown or N/A
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