Pivot a column

Question

I am trying to pivot a row and cant seem to figure out how. I am trying to combine two colums into one column with two rows. At first The names were all contained in one column but I wrote a function to spilt them up into seperate columns.

Here is a sample of the current data

ID MotherLastName   MotherFIrstName   FatherLastName FatherFirstName
 1      Smith           Mary                Smith         Joe

This is what I want

 ID  Lastname  FirstName
  1     Smith     Mary
  1     Smith     Joe

This is something I do often so a function would be ideal. Any suggestions?

Answer 1

0

Based on your example, you just need a UNION :

select ID, MotherLastName as Lastname, MotherFirstName as Firstname
union all
select ID, FatherLastName, FatherFirstName

answered Mar 30 '12 at 01:17 PM

Kev Riley ♦♦
46.1k ● 39 ● 43 ● 69

Thanks that works!!..guess I was reading too much into the problem

Mar 30 '12 at 01:37 PM sqlLearner 1

(comments are locked)

Pivot a column

Follow this question

Related Questions