Click here to Skip to main content
12,548,135 members (49,884 online)
Click here to Skip to main content
Articles » Database » Database » SQL Server » Revisions

Tagged as


6 bookmarked

Extracting Multiple Rows from a Single Row (TSQL)

, 9 Sep 2010 CPOL
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 [...]



Compare Revision Minor Date Status Editor
3 - publicly available No 9-Sep-10 13:31 Available Raymund Macaalay
2 No 1-May-10 3:03 Composing Deeksha Shenoy
1 No 28-Apr-10 9:00 Composing Raymund Macaalay


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Raymund Macaalay
Technical Lead
New Zealand New Zealand

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.161021.1 | Last Updated 9 Sep 2010
Article Copyright 2010 by Raymund Macaalay
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid