Viewing 4 posts - 1 through 4 (of 4 total)
Eugene Elutin (7/3/2014)
Since @CompanyName is also part of the table name it would be easy to leverage sys.objects to see if that table exists.
...
or use OBJECTPROPERTY function.
...
Sean and Eugene...
July 3, 2014 at 11:07 am
ksrikanth77 (7/2/2014)
Hi JamesI am not getting any result or any error when I execute the second query
It produces what I expect on my database. Try replacing the EXEC with PRINT...
July 3, 2014 at 11:04 am
First, you might ask if you really need to replace the cursor. Are there so many company records that it makes a significant difference in comparison to the time it...
July 2, 2014 at 3:59 pm
I'm new to the forum as well, but I've been SQLing a while. I hope that I can be of some help.
Looking at your desired result, I don't see the...
July 2, 2014 at 12:47 am
Viewing 4 posts - 1 through 4 (of 4 total)