INSERT/SELECT statements do us no good, because we don't have access to the tables in the SELECT part of the statement.  You need to provide sample data as INSERT/VALUES statements. ...

I was thinking that for most purposes, an explicit transaction would suffice.


BEGIN TRAN

DELETE statement

INSERT statement

COMMIT TRAN


Drew

You've been around long enough to know to provide sample data and expected results.

Drew

Isn't it as simple as a CASE expression?

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA