Expert Systems – an SSRS Approach
An interesting approach to solving a complicated problem using SSRS. Users have too much documentation to read about a process, so Jonathan Spink introduces a better way to do things.
2010-06-22
7,474 reads
An interesting approach to solving a complicated problem using SSRS. Users have too much documentation to read about a process, so Jonathan Spink introduces a better way to do things.
2010-06-22
7,474 reads
A new product from SoftArtisans makes it easy for Reporting Services users to work in their familiar Word and Excel environments. Longtime author Jonathan Spink brings us a review of this software.
2006-11-01
4,403 reads
In response to his article on using Reporting Services to manage rights, Jonathan Spink takes a look at how Reporting Services can be positioned in your enterprise.
2006-09-12
5,202 reads
Reporting Services is quickly becoming one of the most popular parts of SQL Server and new author Jonathan Spink brings us an interesting use of this subsystem. He explains how Reporting Services can do more than just display data; it can also provide an easy interactive way to make changes without the overhead of a complete .NET application.
2006-08-09
6,889 reads
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Hi - I'm looking for advice regarding the best & quickest way to establish...
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
I have a query that runs in a job to check on orphaned users....
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