THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » expressions » SQL Server   (RSS)
  • Getting Dynamic in SSIS Queries

    When you start working with SQL Server and SSIS, it isn’t long before you find yourself wishing you could change bits of SQL queries dynamically. Most commonly, I see people that want to change the date portion of a query so that you can limit your query to the last 30 days, for example. This can be done using a combination of expressions and ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on March 22, 2010
  • Fun and games with Reporting Services expressions

    I have today been messing about with Reporting Services' expression language and as such have learnt a few things that I figured might be worth sharing. The report that I have been attempting to build has two parameters that define the effective reporting period for the report, effectively they are arguments in a WHERE clause: The business ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 10, 2009
Privacy Statement