SQL Saturday 38 Presentation
This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible....
2010-05-12
390 reads
Brian K. McDonald
SSRS - Time Saver using Templates
Creating a Reporting Services Template
Many companies like to have a consistent look and feel across their applications. Some even make...
2010-05-12
563 reads
Using the Report Items Collection in Reporting Services
Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has...
2010-05-12
481 reads
Time Matters: Part 1
If you’re anything like me, you value every second of your day and you constantly try to find new ways...
2010-05-10
451 reads
Introduction to SSRS 2008 and SQL Saturday 38
In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many...
2010-04-26
352 reads
User Preferences and Styling
This article from Brian McDonalds shows how to allow style preferences from within SQL Server Reporting Services
2009-05-29
3,251 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers