Wedding Query........(SQL Server Stored Procedure Style)

CREATE PROCEDURE MyMarriage
@ BrideGroom Char(NotBad),
@ Bride Char(Good)


AS
BEGIN


SELECT Bride FROM india Brides
WHERE
FatherInLaw = 'Millionaire' AND
CarCount > 2 AND
HouseStatus ='TwoStoreyed' AND
BrideEduStatus='PG orAbove'
HavingBrothers='NO' AND
HavingSisters ='No' AND
AllowRelocate ='YES' AND

SELECT Gold ,Cash,Car,BankBalance FROM FatherInLaw

UPDATE MyBankAccout SET MyBal = MyBal + FatherinLawBal
UPDATE MyLocker SET MyLockerContents = MyLockerContents + FatherinLawGold

INSERT INTO MyCarShed VALUES ('BMW')


END
GO


...


..


..


..


..


..


..


..


..


..


..


..


..


..


..


..


..


..


Then the wife writes the below query:


DROP HUSBAND