I will write and troubleshoot sql server queries with explanations

United Kingdom

I speak English

Python, C Sharp, SQL Server and Excel Support

I help with small Python and C# programs, SQL Server queries, Excel/CSV data cleaning and public web research. My services focus on readable code with run instructions, explained SQL queries, consist...
About this Gig

I write and troubleshoot Microsoft SQL Server (T-SQL) queries and explain how they work.


Useful for:

Reports, filtered lists and joined data

GROUP BY, totals and aggregate functions

Subqueries and basic INSERT, UPDATE or DELETE operations

Fixing SQL errors and making existing queries easier to read


You receive:

Commented .sql query scripts

A plain-English explanation of the logic

Notes on assumptions and how to run the queries

A check against your supplied schema, sample data and expected results


Basic: 1 query using up to 2 tables.

Standard: up to 3 queries using up to 4 tables.

Premium: up to 5 queries using up to 6 tables.

Table limits apply to the agreed set of tables used in the order.


Please send your SQL Server version, table/column structure, existing query and exact error if relevant, anonymised sample data, and the output you need. Message me before ordering if the scope is unclear.


This service covers small, clearly defined query tasks. Database administration, enterprise architecture, migrations and advanced performance tuning are outside these packages.

Database type:

Relational database

Platform:

MS SQL

•

SQL Server

Expertise:

SQL

•

DML

•

DQL