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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-15 : 10:07:17
|
| Rodney writes "Building a new sp got idea on the design but just asking for maybe some more design ideas.a)AvailabilityReply: Stored procedure should return available units and their details Input parameters : 1) ArrivalDate(mm/dd/yyyy) 2) DepartureDate(mm/dd/yyyy) 3) Number of Adults 4) Minimum Bedrooms 5) Number of children 6) Attribute 7) UserId 8) Password Should return Output parameters : 1) Unittype 2) Unitname 3) Propertycode 4) Locationcode 5) Sleeps 6) Price 7) Tax 8} Total 9) Surcharge 10) Deposit 11) Duetobook 12) Description1Thank you for your time.RegardsRodney W. WilsonFirst Resort SoftwareDBA/Development303-604-4885" |
|
|
|
|
|
Creating Store Procedure.