• Sean Lange (4/16/2013)


    Lynn Pettis (4/16/2013)


    Sean Lange (4/16/2013)


    Lynn Pettis (4/16/2013)


    It is also possible to make the synonym unique between invocations of the proc if needed.

    I was wondering about concurrency when I read your reply. I like the idea of a synonym but can't figure out how you could make it unique without resorting to dynamic sql.

    Yea, your right. I was looking at some of my code where this is actually embedded in some more code. Sorry.

    Shoot!!! I was hoping there was something I just wasn't thinking of.

    I was avoiding having to nest dynamic sql. Counting the proper number of single quotes can be quite tedious to say the least.

    However, the use of smoke and mirrors is quite unique.