SBurke, Member
I suppose this is more of a SQL question than myDBR.
We have a query that has a stupid amount of columns. But there will seldom be any rows.
As the report is emailed, we would like some kind of conditional reporting where it would email/display results only if there are any rows to display.
Is it feasible?
myDBR Team, Key Master
You've got few options how to deal with it depending on the complexity of your query:
- Use dbr.no_data
- If the query is a simple one, count the number of rows first into a variable and do the query only if rowcount>0
- If the query is complex, put the output of the query into temp-table and then count rows in temp-table before making the query from temp-table
--
myDBR Team
You must log in to post.