Simply use a UNION
SELECT [Person] as [Perdson],[Billing Street] as [Street], [Billing City] as [City] FROM Tbl
UNION
SELECT [Person],[Home Street] [Home City] from tbl
More Related Contents:
- how to add new method to TextBox Class [closed]
- What is the difference between task and thread?
- Extension method and dynamic object
- What is the ‘dynamic’ type in C# 4.0 used for?
- When to dispose CancellationTokenSource?
- Does Parallel.ForEach limit the number of active threads?
- List thread safety
- Why Interface Layer/Abstract classes required in our project? [closed]
- C# 4.0, optional parameters and params do not work together
- using ITextSharp to extract and update links in an existing PDF
- Contravariance explained
- Overloaded method-group argument confuses overload resolution?
- Iterating over JSON object in C#
- How to get text between nested parentheses?
- C# 4.0: Can I use a TimeSpan as an optional parameter with a default value?
- Why is list when passed without ref to a function acting like passed with ref?
- Limit the number of parallel threads in C#
- How can I simulate a mouse click at a certain position on the screen?
- How to check if a user belongs to an AD group?
- Fastest way to Remove Duplicate Value from a list by lambda
- Why does C# (4.0) not allow co- and contravariance in generic class types?
- C# operator overload for `+=`?
- Dynamically implementing an interface in .NET 4.0 (C#)
- C# – Issues with boxing / unboxing / typecasting ints. I don’t understand
- C#-How to use empty List as optional parameter
- C# Regex to match the word with dot
- VS 2015 SSIS Script Tasks cannot be debugged
- How do I translate an expression tree of one type to a different expression type?
- USB Device Connected
- Visual Studio 2010: How to enforce build order of projects in a solution?