SQL Scripts

Below is a list of SQL Scripts I have posted and found useful.  You are welcome to them:

• Dynamics GP - Reconciling SOP Batches
• Dynamics GP - Deleting Empty SOP Batches
• Dynamics GP - Automating RM Aging
• Dynamics GP - Get the Next Note Index
• Dynamics GP - Who has that SOP Document Locked
• Dynamics GP - Select Salesperson Specific Sales Data from GP
• Dynamics GP - SQL AR Aging by Steve Gray

• General Use - Create Indexes to improve query performance
• General Use - Simple SQL Table Backups
• General Use - Custom Business Alerts with xp_sendmail
• General Use - Select all tables with a specific column
• General Use - Generate Insert Into Script
• General Use - Row by row analysis & manipulation with Cursors