SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
424 reads
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
424 reads
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,350 reads
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
719 reads
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
524 reads
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
652 reads
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
598 reads
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
#33-SSRS 2008 R2 - Indicators, Sparklines and Databars
Speaker: Patrick LeBlanc
Add To...
2010-08-30
1,697 reads
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
477 reads
Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER...
2010-08-27
498 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...
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
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