sql code

The purpose of this stored procedure is to merge dbo.receipts (new receipts), tblStoreData (historical data), and source_mealconnect tables into receipts_vw table (converted from view – necessary for speed). Once the merge is completed, clean-up steps are run:Pre-step remove all records within last 6 months where [comment] = ‘Missing Contributor id […]

SQL example Stored Procedure update_receipt_vw

I worked on this for a government related agency – for their construction department. The need was to pivot source data- a very wide, hard to decipher column data – into hours data by craft, trade, gender, race and by a derived row key (a tall, narrow data table). There […]

SQL Example Workforce Grid