The easiest way to do it is with a Stored Procedure.

If you are using Microsoft SQL Server check out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_5yk3.asp