|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"Extracting Multiple Rows from a Single Row (TSQL)"
I was tasked to create a query for an accounting journal entry from a transaction table with only amounts indicated, so if it’s a journal entry there should be a credit and debit but most of the other values will be similar, so I thought of extracting 2 rows from a single row through SQL [...]
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!