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 |
|
ka.ak
Starting Member
2 Posts |
 Posted - 2011-12-06 : 23:02:46
|
| CREATE A STORED PROCEDURE named new_Showing for adding records to the showing table.i) the procedure should accept the showing date,listing ID,and buyer ID as parametersii) Using the listing ID provided determine the listing statusiii) If the listing status is "I" or "S",then display a message to the user indicating the status of the listing and stating that the property cannot be shown.For example, "this listing is inactive and cannot be shown".iv) 1)if the listing ID provided,determine the listprice for the listing 2) Using the gpbuyer id provided, determine the maximum price the buyer is approved for3)if the listprice is more than 25% greater than the buyer's maximum price,then display a warning message to the user that the list price is significantly higher than the buyer's maximum price. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-06 : 23:21:53
|
| good..now that we've seen your assignment question, you may post what you've tried yet. unless you put in some effort and try to crack this yourself, dont expect to get spoonfed help from anyone.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
STORED PROCEDURE