SSIS Package documentor
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
18,822 reads
Divya Agrawal
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,978 reads
Problem with scripting objects through query
This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.
2009-10-30
2,007 reads
Compatibility issue and CROSS APPLY
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
6,031 reads
Split string using XML
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
15,554 reads
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
22,617 reads
2009-05-25
1,529 reads
Calculate the Running Total for the last five Transactions
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,140 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
4,003 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
Question of the Day
BIT_COUNT 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