One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
3,894 reads
2018-05-18
966 reads
2016-01-29
1,673 reads
Sandeep Mittal provides an introduction to the COALESCE function and shows how to use it.
2015-11-25
4,572 reads
2013-09-20
2,705 reads
2013-06-03
2,597 reads
2012-11-09
2,203 reads
2012-10-17
2,497 reads
This simple script retrieves a range of values from a table and presents the results as a string.
2008-09-15 (first published: 2008-07-16)
1,592 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
one of the Report which calls two Data sets , Data set1 Contains ,...
Comments posted to this topic are about the item Community at PASS Summit
Ask SSC