Sounds fair. If was just and interesting idea. Ofcourse with Yukon this sort of thing will be easy with c# using split.

Nice solution above. I like the use of return tables.

Here is an interesting variation that allows for a large number of parameters based on XML

declare @temp varchar(5000)

--set @temp = 'FLOOR...

A lot of sites use this type of solution. Two servers one for online, the second warm backup for reporting/ batch/redundancy.

If you have a SAN (Storage array Network) or shared...

Guess if you have the money you could look at a cluster of servers. One for online stuff and one for batch.

DN