| http://www.w3.org/ns/prov#value | - If it is a big list of parts and you do lots of lookups, you want want to try Celko's nested set model instead of the adjacency model you currently have.http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=1266295Do be advised that the code was not written specifically for T-SQL and I believe there is an error that misses the right most node that can be easily repaired, but it is well
|