Home Forums SQL Server 2005 T-SQL (SS2K5) Dynamic SQL Giving 'Name not a valid identifier error' RE: Dynamic SQL Giving 'Name not a valid identifier error'

  • Actually, I pulled only that query out of my larger script. Other parts are using dynamic SQL. This one isn't. So you're right. But, I finally got it to work. I copied and pasted line-by-line into another query window. I had copied the core sql statement from a dataset I had previously built in SSRS. We think some rogue character might have gotten in there.

    But, thanks for the posts. I appreciate seeing and learning from what others share.