Checking SQL code for unused column references?

SQLServerCentral » Latest topics

Checking SQL code for unused column references?

I have a couple long (1000+ lines) queries in development. I tend to use a lot of CTEs, and throw in columns that seem helpful at the time, but may not be used in the final query.

Does anyone know a tool that will scan a query and list columns th

more info...