Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the loopin...
2020-04-07
8,447 reads
Problem Many of us are already aware of the loopin...
2020-04-07
8,447 reads
This article explains how to calculate the important statistical functions, MEAN, MEDIAN, and MODE, in both T-SQL and DAX.
2020-02-28
32,886 reads
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
84,158 reads
Learn how to use the PIVOT operator in SQL in a step-by-step manner.
2020-02-06
13,182 reads
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...
Comments posted to this topic are about the item Why you should avoid Implicit...
Hi everyone I am doing some clean up of my DB. There is one...
please help. Do they know if the use of try and catch for error...
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers