We, too, have been practicing this for years, along with the strict caveat, as a previous poster mentioned, that no one ever use a SELECT * in anything, view, stored...

I have used the Report Generator Task posted on Codeplex, and it is a great time saver and works well!

Larry

Perhaps so - I wanted to make the dynamic SQL UPDATES clear, and it does run pretty efficiently as is, but . . . always room for improvement!

Thanks for the...

Thanks for your reply, Bill! Believe it or not, it did cross my mind, however briefly, that "modern management" (is it really new?!) styles might have some new and...

Thanks for your reply! The one other thing you'd have to remember is to up the MaxRecursion when someone ended up with more than 123 direct reports (:-D) ...

Thanks for your reply! I'd be very interested in looking at the book mentioned - as so often happens, the "tyranny of the urgent" resulted in doing some quick...

I had to modify one of those feared and much-maligned triggers in order to let an insert trigger assemble a dynamic SQL statement that only updates (actually modified) columns from...

I finally resolved this issue, after weeks of wrangling with it, off and on . . .

A common practice of mine in SSIS is to set the result of...

Thanks, Tony!

You will also need to create a Split function in your database . . . can be found in lots of places on the web, but here's one variation:

CREATE...

Thanks for your reply!

The key word in that sentence is "report's main dataset includes this in the WHERE clause" . . . in the interest of brevity, I didn't include...

Sorry, it's early (!) - the SharePoint Data Source and Destination connections are, of course, SSIS "plug ins." I did nothing special in the SSRS report - by that...

Thanks - glad you liked it!

No, I didn't do anything special in the SSRS module, other than use the SharePoint data source and destination connections which are standard in Visual...

Brett,

I assume that means you'll find this useful . . . hopefully, better late than never!

Thanks,

Larry

Thanks for your kind words!

Larry

Thanks for your reply!

I really hadn't thought of the nested group situation - I don't think we use that much, so it didn't come up - but I think you...