You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to display different email address types in separate columns

Accepted answer


We have a requirement to display separate columns for work email address and home email address, one row of data per employee.

Content (required):

From reading other posts on the topic of separate columns, it has been recommended to use pivot tables however we would prefer to write this directly into the SQL or XML if possible. I can get data in separate columns using CASE formula however am still seeing two rows per person in the results.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!