>- see footer for list info -<
I have a table where i want to delete some data.
Then using the ID of that table do a tidy up of all the tables affected by
that data using a Stiored Procedure.
I know there are triggers but have never used them. And that data needs to
deleted NOW.
What would be the way in SQL to do the following:
Select ID FROM Table Where Status = 1
LOOP AROUND ABOVE QUERY
Call Stored Procedure to tidy up DB
END LOOP
Thanks for a quick answer pls
Allan
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
