You are not just new to the forums, but have never read anything about RDBMS.
Backoff the new guy, Joe. You don't know if he created the denormalized data or not. Even if he did, that's not teaching and there's no need for that kind of comment.
What you have is an attempt at a variant record in several different 1950's threu 1970's file systems.
BWAA-HAAA!!! You always say stuff like that but aren't you still using a 1950s push-stack to convert Adjacency Lists to Nested Sets?
If you do nto care about being a good SQL programmer, there are several kludges for splitting this string into separate values.
Once again, you're totally out of line with such a comment. Good programmers will, in fact, use some of the "kludges" to normalize the data if they're allowed and to simply use the data if they're not. Heh... and it's not nearly as bad as the push-stack kludge. ;-)
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is usually not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs