|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Monday, December 13, 2010 7:36 AM
Points: 90,
Visits: 34
|
|
| It appears to me a bit of too much work for SQL server. OpenXML has a large overhead associated with it. Beside the code appears fairly difficult for maintenance.
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:46 AM
Points: 96,
Visits: 272
|
|
| Does this work with multiple filters? For example Country = "USA" & Order Date After "1/1/2006". Got an example?
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 8:53 AM
Points: 113,
Visits: 146
|
|
BigSam, Samples are provided (at the bottom) of the article. Here is your specific one.
print 'Filter on specific Countries and OrderDate'
EXEC uspOrderDetailsGetByXmlParams '
<ParametersDS>
<CustomerCountry>
<CountryName>USA</CountryName>
</CustomerCountry>
<SingleValueParam>
<OrderDateAfter>1/1/2006</OrderDateAfter>
</SingleValueParam>
</ParametersDS>
'
|
|
|
|