I came accross this while I was looking for an answer to an issue i am having, basically I have seen that if the Execute SQL Task has a command...

bobh0526 (5/5/2010)

---

WHERE (surgeries.sur_or_start_datetime BETWEEN CONVERT(datetime, @StartDate, 120) AND CONVERT(datetime, @EndDate, 120) + 1) AND

(surgeries.sur_hospital_service IN (@Service)) AND (surgeries.sur_wound_class = @WoundClass) AND

(surgeries.sur_primary_surgeon_dr_name = @SurgeonName)

OR

(surgeries.sur_or_start_datetime BETWEEN CONVERT(datetime, @StartDate, 120)...

Hey, great article, just two quick comments, there is a SSISMultipleHash task on Codeplex that is very nice for this, (I'm not the developer, but I use it), you can...

You can try this if you want, I am really new to SSRS, and even newer to VB custom code, but I created two functions to accomplish this, and you...