Jeff Moden wrote:
I down voted everything on that post. None of the people involved including the original poster, the two people that posted the answers, the idiot that edited the original and follow up post, or any of the moroffs that upvoted the currently accepted answer realized that you can't do an EXEC on a bloody table name. Typical "brilliant" SO thread. It would also appear that a couple of us also missed that. 😉 That being said, it might make a nice "ace breaker/RTFQ" question on an interview test. 😀
Honestly, I wasn't looking that closely at the original post because I knew the source of his error was different than mine as soon as I saw the OPEN ROWSET. Instead of checking the rest of his code, I went parsing the answers to see if they might offer something I needed.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.