OMG.

/me sends plate of blueberry muffins to Hatton as a ... er ...
Distraction.

/me resists temptation to copy it and run it to check for errors...


>>| -----Original Message-----
>>| From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
>>| Sent: Wednesday, March 26, 2003 4:18 PM
>>| To: CF-Community
>>| Subject: RE: You know you're a web dev junkie when...
>>| 
>>| 
>>| Worse, you rewrite the whole thing in a stored procedure
>>| 
>>| CREATE PROCEDURE up_schedule_lunch
>>| @cName VarChar(150),
>>| @cQuestionText VarChar(500)
>>| 
>>| AS
>>| 
>>| DECLARE @lFundCheck BIT
>>| 
>>| SET @lFundCheck = (SELECT CASE WHEN @nBalance <= 10 THEN 0 
>>| ELSE 1 END as
>>| lFundCheck FROM CoWorkers WHERE Name = @cName AND Question 
>>| = @cQuestion)
>>| 
>>| IF @lFundCheck = 0
>>|     UPDATE CoworkerProfiles
>>|     SET Funds = '10.00'
>>|     FROM CoworkerProfiles
>>|     INNER JOIN CoWorkers ON
>>|     CoWorkers.CoWorkers_id = CoworkerProfiles.CoWorkers_id
>>|     WHERE CoWorkers.Name = @cName
>>| 
>>| GO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

                                Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
                                

Reply via email to