T-SQL: Converting Rows to Columns with SQL Scripting
In database design it can be nice to have a very flexible database for logging or configuration of resources. This flexibility is obtained by normalizing your database design to the third normal form (3NF) or beyond. One situation that may come up is that a table may have key/value pairs that link to another table …read more