Category Archives: sql server

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

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

PASS Board of Directors – Who I’m Voting For

Posted on December 15, 2011 by Jen McCown

I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD election, ending 12/20.  Here is Nic’s take on the subject. So, who am I voting for? I’m not telling you. It’s not that … Continue reading →

Posted in Community, News, sql server, SQLPASS, sqlserverpedia-syndication, SSC | Tagged | Leave a comment