Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...
2013-12-24
23 reads
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...
2013-12-24
18 reads
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In MDX, when two or more members...
2013-12-19 (first published: 2013-12-15)
1,575 reads
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...
2013-12-15
30 reads
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...
2013-12-15
15 reads
The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on...
2013-12-08
789 reads
The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression. The syntax of the...
2013-12-08
23 reads
The MDX language includes an ORDER function that orders members of a set in ascending or descending order based on a numeric (or string) expression. The syntax of the...
2013-12-08
13 reads
The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these...
2013-12-04
2,204 reads
The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these parameter settings and determined that the following appear to...
2013-12-04
27 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers