Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
2019-09-20 (first published: 2003-08-26)
73,045 reads
Masar Ivica
Generating a Bar Code
SQL Server is asked to do many tasks, including scheduling processes, transferring data using DTS in an ETL process, sending mail, updating other systems, generating reports and more. However this one might a bit unsual: using SQL Server and T-SQL to generate a bar code. Ivaca Masar brings us this unique look at how you can stretch the limits of T-SQL.
2005-02-08
13,561 reads
Creating a Chart From a Table
New author! This article has a stored procedure that will generate an HTML document - as long as the table has the proper schema. If you try it, be sure to download the associated zip which has some images and the script for the stored procedure.
2003-07-23
7,758 reads
Blogs
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Heading to 2024 PASS Summit
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
Tell me the positives of your solution
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing AWS data by using...
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers