Thanks Cadace.
I had to create the SP, but still got the same results... the only columns that are generated are
rowid, ViewDetailLink, ViewDetailLinkURL. I think these come from the Template don't they?
It makes me wonder what triggers the SP to run? Is it possible that whaterver it is... isn't in the code?