srinivas P

srinivas P

  • NA
  • 168
  • 194.1k

How split row into multiple rows using sqlserver?

Sep 2 2011 7:20 AM
 My table like this 


Name       

Address
sri ni vasa Raohyderabad plotno:109 Dsnr
Sravan kumarGuntur HNo:1001 
sandhya      Guntur 

My Requirement is
NameAddress
sriHyderabad
niplotNo:109
vasaDsnr
Rao
sravanGuntur
kumarHNo:1001 
sandhyaGuntur

How to solve this one?
Help me

Answers (2)