C:\Test>sqlcmd -S localhost\TESTINSTANCE -i test.sql -v filepath=".\"

Changed database context to 'TEST_DB'.
Msg 137, Level 15, State 2, Server TOM\TESTINSTANCE, Line 18
Must declare the scalar variable "@indate".

CREATE TABLE EMP (EMPID INT, EMPNAME VARCHAR(50), EMP_JOIN_DATE DATETIME);

USE TEST_DB
GO
:r $(filePath)Upgrade_Script.sql
:r $(filePath)Create_StoredProcedures.sql
GO

USE master
--GO

--50001
IF EXISTS(SELECT * FROM sys.messages WHERE message_id = 50001)
BEGIN
exec sp_dropmessage 50001
END
--go

PRINT '------------------------------------------------------------------------------------------------------------------------------------------------------------------'
print ' End of Upgrade_Script '
PRINT '------------------------------------------------------------------------------------------------------------------------------------------------------------------'
PRINT ' '
--GO

CREATE PROCEDURE [TEST_DB].[dbo].[GetSP] @indate DateTime AS
BEGIN
SET NOCOUNT ON
SELECT * FROM EMP WHERE EMP_JOIN_DATE > @indate;
END
--GO