Hi all, I'm trying to optimize a query combination. In CF I'd do a select statement and if there was no rows returned from the select, I'd do an insert. Basically I'm making sure a value does not exist before entering it. I'm thinking that putting this logic into a stored procedure might be a good idea. The only problem is, I don't (currently) know how to do the part where I check if the select returns data. Is there a MS SQL function to say queryreturnsdata() or the like? Is there a better way?
Thanks -- Michael Dinowitz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3322 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
