dynamic update to SP

Question

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Bruin SSCrazy Points: 2107 More actions · Answer 1

Thanks for all replies!!

Will test out Emperor100 solution. Just need a way to update the sp's that use this table structure when new month starts.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 2

Bruin wrote:

Thanks for all replies!!
Will test out Emperor100 solution. Just need a way to update the sp's that use this table structure when new month starts.

The synonym suggestion avoids the use of dynamic SQL, and for that reason alone is the better solution, in my opinion.