Case Statement Tricks
The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it. Item translation One of the simplest things you can do is to derive a columns contents based on it’s contents, or the contents of another data item. SELECT...
Concatenating Row Values in Transact-SQL
Concatenating Row Values in Transact-SQL There are a number of solutions and considerable debate. How do you go about Concatenating Row values. By 'Concatenating row values' we mean this: You have a table, view or result that looks like below......and...
How to Insert Values into an Identity Column in SQL Server
Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It's actually very easy to do. First we'll need...