Category: Tips

Little Workaround in Report Manager

Post author By Jen McCown
Post date September 9, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on Little Workaround in Report Manager

I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report), and from there clicking a link to generate and export a subreport (say, Individual Widget Report). The problem with this is that it wipes out initial report and its parameters…so every single time, I had […]

We Are TOTALLY Amused: A T-SQL Error

Post author By Jen McCown
Post date August 11, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
2 Comments on We Are TOTALLY Amused: A T-SQL Error

This has to be the best error I’ve ever seen: Msg 195, Level 15, State 10, Line 2 ‘SUM’ is not a recognized built-in function name. Uhm, I’m sorry to contradict you SQL Server, but yes it is. Here’s the code that produced that error: SELECT keyID , SUM(CASE WHEN printDate IS NULL THEN 1 ELSE […]

Search Argument Case Study: WHERE the year was 2002…

Post author By Jen McCown
Post date July 18, 2011
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
2 Comments on Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query. Here’s a quick demonstration of the power of a well-thought-out search clause on a date column. For this example we’ll use AdventureWorks (freely available at Codeplex). Let’s […]