I have this monsterous "report-to" query that necessitates the use of the following
Select columns from tables where reports_to > ' '
Select columns from tables where reports_to =' '.
I had to do this because the records with the blank values would be repeated a zillion times.
Do you see how this query could be designed differently. I have not used any of the optimizing tools in sql query Analyzer to see it the query is effecient yet. But I will do this as soon as I get the DBA to give me permission to these tools.