Category Archives: sqlserverpedia-syndication

SSRS Tip: Hide a tablix if no rows returned

Posted on January 19, 2012 by Jen McCown

I have a tablix in an SSRS report, populated by a query that might or might not return any rows.  What I want to do is make that tablix invisible if there are no rows returned. First off, to set … Continue reading →

Posted in sqlserverpedia-syndication, SSC, SSRS, Tips | 2 Comments

Answer the Question Asked

Posted on January 13, 2012 by Jen McCown

“Bill, are you running SQL R2 on your desktop?” This seems like a simple enough question, yet I usually cannot get an answer to a question like this on the first try. Why? The simple answer is that people don’t … Continue reading →

Posted in Random helpfulness, sqlserverpedia-syndication, SSC | Tagged , | 4 Comments

SELECT GetDate() – 30 AS [This actually works??];

Posted on December 19, 2011 by Jen McCown

I just ran across this in a piece of code (that I didn’t write): … WHERE Thing >GETDATE()- 30 Aaaand it works. If you run the title of this blog post, you’ll get the date 30 days ago. I had … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, TSQL | 4 Comments