Asynchronous script transform (google that phrase) to transform the input properly would be my recommendation here. You have a variable set of inputs you want to control for.
The other option is delivery in full to a staging table, then use UNPIVOT and/or a UNION, followed by stripping out your NULL entries in T-SQL.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA