text: ﻿CREATE PROCEDURE [{{cookiecutter.test_schema_name}}].[{{cookiecutter.test_name}}]
  AS
  BEGIN
  	--ASSEMBLE
  	IF OBJECT_ID('[{{cookiecutter.test_schema_name}}].ACTUAL') IS NOT NULL DROP TABLE [{{cookiecutter.test_schema_name}}].ACTUAL;
  	IF OBJECT_ID('[{{cookiecutter.test_schema_name}}].EXPECTED') IS NOT NULL DROP TABLE [{{cookiecutter.test_schema_name}}].EXPECTED;
  
  	/*Do you need to fake tables and insert rows?
  	EXECUTE tSQLt.FakeTable @TableName = '[{{cookiecutter.schema_under_test}}].TableName';
  	*/
  	/*Do you need to spyprocedure?
  	EXECUTE tSQLt.SpyProcedure @ProcedureName = '[{{cookiecutter.schema_under_test}}].ProcedureName'
  	--,@CommandToExecute = 'SELECT 1'
  	SELECT _id_, MyParameterName1, MyParameterName2 FROM [{{cookiecutter.schema_under_test}}].ProcedureName_SpyProcedureLog
  	SELECT COUNT(1) FROM [{{cookiecutter.schema_under_test}}].ProcedureName_SpyProcedureLog
  	*/
  
  	--ACT
  	EXECUTE tSQLt.ExpectException @ExpectedMessage = N'Blah. Get this after a trial run.'
  
  	--ASSERT
  	EXECUTE [{{cookiecutter.schema_under_test}}].[{{cookiecutter.object_under_test}}];
  
  END
  
  /****
  Script generated by cookiecutter, for completion by user.
  https://github.com/sdoubleday/cookiecutter-tsqlt-class-vs
  This test compares the contents of EXPECTED and ACTUAL.
  ****/
  /****
  Suggestion: Update the @ExpectedMessage once you know
  your error message.
  ****/
  