Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

The Zero to N Parameter Problem Expand / Collapse
Author
Message
Posted Wednesday, February 28, 2007 10:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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.
Post #348386
Posted Tuesday, March 20, 2007 12:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 6:38 AM
Points: 104, Visits: 305
Does this work with multiple filters? For example Country = "USA" & Order Date After "1/1/2006". Got an example?
Post #352760
Posted Tuesday, March 20, 2007 2:16 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 04, 2014 7:31 AM
Points: 117, Visits: 176

 

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>

'

 

 




Post #352799
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse