Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
chbala85
Starting Member
49 Posts |
Posted - 2013-08-23 : 12:02:54
|
Hi all,i have table like belowpatients:paid name cptcd c1 c2 c3 loc1 aaa cpd9 oc1 oc2 oc3 aa2 bbb cpd9 oc1 oc3 bb3 ddd cpd9 oc1 oc3 cc4 eee cpd9 oc1 oc2 ddi need insert data into another table like below paid name cptcd codeinfo loc1 aaa cpd9 oc1 aa1 aaa cpd9 oc2 aa1 aaa cpd9 oc3 aa2 bbb cpd9 oc1 bb2 bbb cpd9 oc3 bb3 ddd cpd9 oc1 cc3 ddd cpd9 oc3 cc4 eee cpd9 oc1 dd4 eee cpd9 oc2 ddplease help me ...................... |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-23 : 13:28:12
|
Use unpivot:INSERT INTO YourNewTable (paid, name, cptcd, codeinfo, loc)SELECT paid, name, cptcd, codeinf, locFROM PatientsUNPIVOT (codeinfo FOR newLoc IN ([c1],[c2],[c3])) U |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-24 : 11:15:19
|
Also this if its in version before 2005SELECT paid, name, cptcd, codeinf, c1 AS locFROM PatientsUNION ALLSELECT paid, name, cptcd, codeinf, c2FROM PatientsUNION ALLSELECT paid, name, cptcd, codeinfo, c3FROM Patients ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-24 : 11:15:51
|
quote: Originally posted by James K Use unpivot:INSERT INTO YourNewTable (paid, name, cptcd, codeinfo, loc)SELECT paid, name, cptcd, codeinfo, newlocFROM PatientsUNPIVOT (codeinfo FOR newLoc IN ([c1],[c2],[c3])) U
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|