Stan Kulp


SQLServerCentral Article

Generate QR Code® barcodes in an SSRS report with the QRCoder library

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.

5 (4)

2020-11-20 (first published: )

5,212 reads

SQLServerCentral Article

SSRS Audit: All reports executed/not-executed during previous 30 days

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.

4.93 (15)

2020-01-17 (first published: )

8,680 reads

SQLServerCentral Article

Parse Data from a Field Containing Multiple Values using CROSS APPLY

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

3.27 (15)

2019-06-07 (first published: )

11,694 reads

SQLServerCentral Article

Generate QR Code® barcodes in an SSRS report with the QRCoder library

QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.

4.67 (9)

2018-10-22

26,497 reads

SQLServerCentral Article

Generate two-dimensional QR Code® bar codes in an SSRS report

QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.

4.76 (38)

2018-10-22 (first published: )

13,772 reads

SQLServerCentral Article

How to execute an SSIS package from the command line or a batch file

An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command line utility.

4.86 (14)

2018-08-31 (first published: )

75,175 reads

Blogs

Daily Coping 17 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

The book that made me love goal-setting

By

Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...

Daily Coping 16 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Error : Sql Query

By akhil

Hi, I'm struggling to solve this problem. count, for each couple of stations, the...

SQL Query

By akhil

Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...

Combine or join 3 tables, 1 for each databases

By pedroccamara

Hello guys, I hope you're all great and healthy I would love to learn...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers