http://www.w3.org/ns/prov#value | - In fact, here is an article on what a Tally table is and how it can be used to replace While loops...http://www.sqlservercentral.com/articles/TSQL/62867/The last part of that article tells you how to do a "split.For much more detail on how to do both simple split is and how to pass arrays as parameters, here is a different article...http://www.sqlservercentral.com/articles/T-SQL/63003/
|