Andrew Watson-478275 (7/4/2012)

---

I'm curious as to what circumstances you would plan on using this script - the hard part is usually getting developers to include comments in the first place;...

The fine line between sellable and edible is a time critial problem, but not impossible.

I'll help where I can - contact me on twitter @UKGav

I'm sure there is...

Oh, strange! @pdbrewer is also doing Open Data stuff as he works for B&H Council. Check him out..

Anyway, I'll be looking at your article in detail when I have time,...

Just for starters, are you @pdbrewer on twitter?

I tried that and it didn't work.

I didn't expect it to work either as = '%' is not valid SQL, it would need to be LIKE '%' but that isn't...

Ok so this is cool to profile a column, but... 🙂

How could this be run/changed to return multiple rows for each column in a table?

~ UKGav

I haven't had the oppertunity to do that (or read up if its a new feauture) so thanks, much appresiated!

- @UKGav

http://twitter.com/ukgav

I would be awesome if you could include @ParameterName in subscriptions or filenames ... Come on Microsoft, make it so...

I had to use subqueries for 1-to-many tables where I needed to only return only 1 row for each record (Select top 1 date from InnerTable joined to OuterTable order...

I found this interesting, but have not tried it out thus far.

What would be nice is if the script had commented explanations of exactly what each piece of code is...

I made a function for this and named...

This looks very interesting (I've not tried it out myself as at time of writting), however isn't it RBAR using the cursor? Or rather DBAD ... Database By Agonising Database!...

I did manage to find one article showing you how your could make a stored procedure to actually execute the report from, providing the parameters. However this only worked...

Gaby,

Good stuff, thanks.

I like to be really description and accurate with my column titles and I kept changing my mind what to call the date column.

Finally settled on LatestDate since...

Gaby,

Points noted. (Indexes haven't been my job / of my concern yet)

Did you try my edit out?

If so what did you think / can you think of any further improvements?

-...