Query Development

SQL Server – Using TRANSLATE to replace multiple REPLACE

September 28th, 2021
0
Database Query Development SQL Server

SQL Server - How to identify the store closest to the customer (or the distance between 2 locations) from the zip code (without API)

SQL Server – How to filter and separate the number and text of a string

SQL Server – How to consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR

June 10st, 2021
0
Database CLR Query Development Integrations SQL Server

SQL Server – How to write a full number in Portuguese and English using T-SQL function

SQL Server - The “new” GREATEST and LEAST functions

November 27th, 2020
1
Database Query Development SQL Server

SQL Server - How to know how long a specific database has been online

October 30th, 2020
1
Database Query Development Maintenance SQL Server

SQL Server - How to send the contents of a table or query in the body of the email as HTML

SQL Server and Power BI: How to load Stored Procedure data into SQL Server with DirectQuery

June 16st, 2020
2
Database Business Intelligence (BI) Query Development Hacks Power BI SQL Server

SQL Server - How to export the contents of a column to XML files