There are a host of stored procedures in side the product which allow you to:
Using an Engineer sproc is always preferable to coding something yourself as it's been tested and (probably) used many times.
If you're using a script repeatedly it should probably be an Engineer sproc. If so please send the script to DB.
Once the engineer sproc has been created by DB, we will need to create documentation for it and will require the following template. Send this over to AM, this will be added to the list of sprocs below and document linked to that sproc.
Template : advance_retail_sproc_template.doc
To view the engineer sproc run the stored procedure “engineer” to get a listing of all engineer sprocs.