Hi Gosta,

well spotted on the errors in the code, I agree the connection should just be opened once.

@Ron, the Param1, 2, etc would in that code be variants...

Ok, although I would begin with a caveat that A)this maybe could be done on the server side mostly by storing the results in a table before putting them in...

@LadyReader - will the values in the first 3 columns be changed by the user? I presume then you know what they say about assumptions...

sgleeson (10/9/2009)

---

Indeed, I guess I just prefer to keep VBA out of the picture for security compliance where possible. You can wrap the view with a patameterized proc and...

...and that's where VBA helps you out because you can dynamically construct a WHERE clause for your Select from the view, with "Parameters"

I've been using Excel as the presentation layer of my reporting for ages now, I just found it to be quick and versatile, plus people can play around with the...

For sure, Temporal design can save many many headaches down the line.

A system I recently worked on had a very nice facility in addition to temporal data attached to the...

I'm inclined to agree with Mauro - to me it makes more sense to have the Promotion start and end date in the Promotions table, not the PromotedProducts table.

That then...

Good approach given the lack of alternatives, I've used the XML approach before and it can really provide a huge performance boost - but how would you handle error cases...