Countdown

One of the notifications I have in Vineyardsoft Knowledgesync event manager is one to let us know how many of our products don't have a box size and weight on file.  We have a guy in the warehouse who is supposed to let us know when he ships something with no box and weight size filled in, what the correct one is.  Unfortunately, that hasn't happened much, and so we have quite a few that need box and weights filled in.

We started with over 5000 sku's that need this information.  It has been a slow effort to get it to trickle in.  So to better track the info, I was asked to include a count of how many items are on the report.  Previously we were copying it to Excel and seeing how many rows there were.

So the first idea is to add count(dbo.imitmidx_sql.item_no) to the query...

First thought

However, I had a bad feeling that wasn't going to work out too well.... I was right.

Error message

So, in order to bypass this lack of "group by" clause, I opted to just do a second query definition.

New query definition

I copied my original one, and added a "part 2" to the name and description to keep them straight.  Then I removed all of the columns and put in my counter.

New additional query

Presto!  We have a counter now!  3546 more items to go!