Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2017-06-08 (first published: 2017-06-01)

498 reads

List Expressions and Values of Variables in SSIS package

Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-11-17 (first published: 2015-10-18)

2,159 reads

Blogs

A cryptic message, a book cipher hidden in art provenance records, and a trail...

A customer was trying to compare two tables and capture a state as a...

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       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;