Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
26,129 reads
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
26,129 reads
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
9,640 reads
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,215 reads
The post The pros and cons of self-service BI: What every industry leader should...
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
insert into NewKms8081..members SELECT (select u2.Id from SecurityKms8081..users u2 join SecurityKms8081..Import_users_barghGharb i2 on i2.code_personeli=u2.PersonnelNumber...
I am running SQL Server 20.2. When I copy a query into the query...
Hi, i considered power bi with embedded for this. Not a big fan...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers