SQL Server Data Queries Expert
Budget: $250 – $750 USD
I need an experienced SQL Server professional to query various data fields from different files using SQL Server Management Studio (SQL Server 9.0.4060). The project involves:
- Querying the Customer File to determine credit limits, specifically using the Customer ID and Credit Limit fields.
- Querying the Inventory Master File, utilizing the Item ID, Item Description, and Quantity on Hand fields.
- Running queries on Inventory Alternatives (cross references).
- Querying comprehensive Customer data including Open Invoices, Sales History, Vendor Open Invoices, Purchase History, On-Hand Balances, VMI Bins, Open Sales Orders, and Open Purchase Orders.
The ideal candidate should be proficient in SQL and have significant experience working with Microsoft SQL Server Management Studio. Ability to rerun queries for a specified go-live date is also essential.
- Querying the Customer File to determine credit limits, specifically using the Customer ID and Credit Limit fields.
- Querying the Inventory Master File, utilizing the Item ID, Item Description, and Quantity on Hand fields.
- Running queries on Inventory Alternatives (cross references).
- Querying comprehensive Customer data including Open Invoices, Sales History, Vendor Open Invoices, Purchase History, On-Hand Balances, VMI Bins, Open Sales Orders, and Open Purchase Orders.
The ideal candidate should be proficient in SQL and have significant experience working with Microsoft SQL Server Management Studio. Ability to rerun queries for a specified go-live date is also essential.