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 |
|
syedtameem11
Starting Member
6 Posts |
 Posted - 2009-05-18 : 06:41:51
|
| Hi All,I want to write a stored procedure in which data is got from the xml from database and should select the values in that xml data type randomly, so that i can insert huge amount of data using that stored procedure.Must get random values from that xml data type for insertion into another table.Thanking you,Syed |
|
|
syedtameem11
Starting Member
6 Posts |
Posted - 2009-05-18 : 07:31:46
|
| Sorry, I will complete the forum.For example an xml file is<Cities><City id ="1">Hyderabad</City> <City id="2">Bangalore</City> etc. I want to get random selection from that column which is in xml data type formatThanksSyed Tameemuddin |
 |
|
|
|
|
|
Random data retrieving from xml data type