Welcome to MSDN Blogs Sign in | Join | Help

May 2009 - Posts

The “magic” about trustable relationships with NULL and NOT IN
  As a follow-up to my former post “ Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate ” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL Read More...
Posted: Monday, May 25, 2009 8:52 PM by Jens K. Suessmeyer | 1 Comments
Filed under: , , , ,
Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 2
(Sample project attached to the blog entry !)   Having stated the need for getting data from SSIS packages in Reporting Service in my last post (Part 1) , we now want to concentrate how to achieve the implementation. SQL Server Integration Services Read More...
Posted: Tuesday, May 12, 2009 7:39 AM by Jens K. Suessmeyer | 2 Comments
Filed under: , , , ,
Getting feedback / progress from batches and stored procedures
Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you Read More...
Posted: Monday, May 11, 2009 10:42 AM by Jens K. Suessmeyer | 5 Comments
Filed under: , , , , ,
Page view tracker