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 |
|
raviborra
Starting Member
14 Posts |
 Posted - 2008-06-30 : 07:30:29
|
| Hi,I need to get data from the XML to Data Table dynamically based on search criteria in the Stored Proc.Could any one please suggest the best solution.Thanks,BRK. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-30 : 07:45:49
|
| read about OPENXML in booksonlinehttp://msdn.microsoft.com/en-us/library/aa276847(SQL.80).aspx |
 |
|
|
raviborra
Starting Member
14 Posts |
Posted - 2008-06-30 : 08:02:26
|
| OpenXml is not suitable here, because search criteria should come from dynamically.That means search parameters are one or many.It depends, so i need to filter the XML dynamically. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-30 : 08:26:34
|
quote:
Originally posted by raviborra
OpenXml is not suitable here, because search criteria should come from dynamically.That means search parameters are one or many.It depends, so i need to filter the XML dynamically.
Are you storing xml in a xml datatype field? |
|
|
|
raviborra
Starting Member
14 Posts |
Posted - 2008-06-30 : 08:42:50
|
| No, I am stroing in VARCHAR field |
|
|
|
|
|
|
Filling temp table from XML based on searchcritera