SQL translator › Snowflake → T-SQL
Snowflake to SQL Server translator
Snowflake QUALIFY filters a window in one clause. SQL Server needs a derived table.
Usual swaps
| Snowflake | SQL Server |
|---|---|
| QUALIFY | subquery + WHERE on the window column |
| LIMIT | TOP / OFFSET FETCH |
| ILIKE | LIKE (CI) |
| IFF(a,b,c) | IIF(a, b, c) |
| NVL / IFNULL | ISNULL |
| LISTAGG | STRING_AGG |
| TO_VARCHAR | CONVERT(varchar, …) |
| VARIANT / PARSE_JSON | OPENJSON … WITH |
| ::type | CAST |
QUALIFY rn = 1 is the “latest per customer” pattern. See /interview/latest-per-customer.
Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free