SoftadminGuide.Generate_Grid_StaticSql

Creates the static sql procedure for a Grid menuitem.
Expects the temp tables

CREATE TABLE #SelectColumns
(
	ColumnName sysname NOT NULL,
	SortOrder int NULL
);

(optional)
CREATE TABLE #WhereColumns
(
	ColumnName sysname NOT NULL,
	DataType nvarchar(160) NOT NULL,
	SortOrder int NULL
);

The tables may be created from SoftadminGuide.Table_AllColumns or SoftadminGuide.ParseField_Columns (assuming it does not involve any joins). See the documentation of those functions for further explaination of the columns.