I'm new to this forum and writing queries as well.

I have tried running this script in Management Studio and it runs fine, however if I try to build a report...