Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
19,414 reads
Geoff Norman
How well do you really know your colleagues?
Take your peers out of their comfort zone and do you know how well they'll perform?
2010-07-08
268 reads
2009-02-12
6,724 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Source to Target Mapping (Lineage)
Hi all, I work with an unusual warehouse and I was wondering if anyone...
How do I read XEL files in SSAS?
A colleague of mine has setup SSAS monitoring through Extended Events and these are...
Question of the Day
The Character choice
What happens when I run this code in SQL Server 2022?
create table Names ( namestring varchar(20)) go insert Names select 'Steve' go select choose(namestring, 'steve', 'andy', 'brian') from NamesSee possible answers