Unable to use undeclared variable

0 votes

1 answer

234 views

                              DECLARE @LINKEDSERVER VARCHAR(20)= 'LS_CMT';
            DECLARE @ODS_DBNAME VARCHAR(20)= '';
            SET @ODS_DBNAME = DB_NAME();
    		DECLARE @OCS_DBNAME VARCHAR(20)= '';
            SET @OCS_DBNAME = 'CMT' + SUBSTRING(@ODS_DBNAME, CHARINDEX('_', @ODS_DBNAME), LEN(@ODS_DBNAME))
    SELECT * FROM @ODS_DBNAME.[dbo].CLI_LOCATIONS


                        

Asked by SAJAL (11 rep)

Jul 31, 2020, 08:14 AM
Last activity: Jun 12, 2025, 01:09 PM

Unable to use undeclared variable

Related Questions