SQL Customer Data Export
Budget: $250 – $750 USD
I need the full set of customer-related records lifted from my SQL database and dropped into a single worksheet that follows a template I’ll send you. The database holds tables for customers, payments, customer relations, sales and units. Your job is to write the necessary SQL (views, joins or stored procedures—whatever is most efficient), run it, and populate the template with:
• each customer’s name and contact details
• their complete purchase history and account status
• the matching payment, sales and unit information
Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the process later.
Accuracy and clean formatting matter more to me than speed. If you’re comfortable working directly in SQL Server (or another flavour—just let me know), and can hand back a ready-to-use file plus the repeatable query, this task should be straightforward.
• each customer’s name and contact details
• their complete purchase history and account status
• the matching payment, sales and unit information
Everything must end up in one sheet exactly where the template expects it, so column order and data types have to match. Once the file is filled, deliver it back together with the extraction script or query so I can repeat the process later.
Accuracy and clean formatting matter more to me than speed. If you’re comfortable working directly in SQL Server (or another flavour—just let me know), and can hand back a ready-to-use file plus the repeatable query, this task should be straightforward.