The purpose to use it is that I need to create a store procedure to read one Order table. Based on server status, sometime user need to change server name from application. The store procedure should be something like below so that user can switch server name by passing parameter @dailytablepath

CREATE PROCEDURE InitList

@dailytablepath varchar(20)

AS

BEGIN

SET NOCOUNT ON;

SELECT *

FROM @dailytablepath + '[ORDER]'

END