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 |
|
stowaway
Starting Member
7 Posts |
 Posted - 2011-06-01 : 01:37:33
|
| I have a webpage that I want to be able to search quotes.The user can select multiple pickup cities, multiple delviery cities and multiple cargo types.so I need to create a stored procedure in effect that can doselect * from quotes where pickupaddress in (@pickupAddresses)and deliveryaddress in (@deliveryaddress)and cargotype in (@cargotype)However obviosuly i an not do this.. Any ideas how I would do a work around? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Multiple Arrays