CleanCode::SQL::SP

This site will work and look better in a browser that supports web standards, but it is accessible to any browser or Internet device.

SP_map

N U T S H E L L
Module	SP_map
Description	SP_map a list or a matrix to an arbitrary DML statement
Environment	SQL Server 2000/2005
Author	Michael Sorens
Since	CleanCode 0.9.17

Usage and Parameters

SP_map @StmtTemplate, @MainArray, @AuxArray, @Permute, @Accumulate, @AccumulateFilter, @Verbose, @Process

where:
   @StmtTemplate      ::= [DML statement]
   @MainArray         ::= "'" { [main item] "," } [main item] "'" | [select statement]
   @AuxArray          ::= "'" { [aux item]  "," } [aux item]  "'" | [select statement]
   @Permute           ::= "1" to perform all permutations, or "0" to match indices
   @Accumulate        ::= "1" for single result set; "0" for individual result sets
   @AccumulateFilter  ::= [filtering predicate]
   @Verbose           ::= "0"-"3" for no diagnostic output or progressively more
   @Process           ::= "1" to execute; "0" to only show generated statements