SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-01
2,388 reads
Patrick LeBlanc
Upcoming SQL Lunch Webinars
If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL...
2010-02-24
1,007 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
727 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
770 reads
Reporting Services Switch Function
Recently a client requested to create a Reporting Services expression that emulated the CASE WHEN statement from T-SQL. The expression...
2010-02-19
4,257 reads
Reporting Services - Disable Loop Back Check
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading...
2010-02-17
716 reads
Set your Warehouse Database to Read Only
In most environments new data is added to the data warehouse daily, weekly or even monthly.Even further, these changes typically...
2010-02-15
718 reads
Technet and MSDN coming to Baton Rouge
On March 4th Microsoft will be hosting two half-day events in Baton Rouge, LA.These free live learning sessions will explore...
2010-02-15
718 reads
Recap - SQL Saturday #32 Tampa
This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.First, I just want to...
2010-01-24
492 reads
PASS Virtual Meeting - Zero to Cube in 60 Minutes
PASS Virtual Meeting
Speaker: Adam Jorgensen
Topic: Zero to cube in 60 Minutes
Date and Time: 1/22/2010 12:00 PM EST
Meeting URL: Join Meeting
Description:...
2010-01-21
671 reads
Blogs
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers