quote:

---

I just need to add one last section, how can I indicate if the stored procedure actually added a row to the table?

---

@REM ***************************************************
@ECHO OFF

SET Server=malazan
SET DB=ScratchPad
SET SQL_SELECT=
SET SQL_EXEC=
SET LogFile=C:\Temp\Log.txt
SET ResultsFile=C:\Temp\Results.txt

SET SQL_SELECT=%SQL_SELECT% SET NOCOUNT ON
SET SQL_SELECT=%SQL_SELECT% SELECT DISTINCT Col1,Col2 FROM TestSQLCMDTab
@REM CALL SQLCMD -Q "exit( %SQL_SELECT% )" /b /S %Server% /d %DB% 

CALL OSQL -Q "exit( %SQL_SELECT% )" -S%Server% -d%DB% -E -b

set /p var1= Enter Col1: 
set /p var2= Enter Col2: 

SET SQL_EXEC=%SQL_EXEC% SET NOCOUNT ON
SET SQL_EXEC=%SQL_EXEC% DECLARE @RetVal int
SET SQL_EXEC=%SQL_EXEC% DECLARE @RowsAffected int
SET SQL_EXEC=%SQL_EXEC% EXEC @RetVal = TestSQLCMDSP %var1%,%var2%,@RowsAffected OUT
SET SQL_EXEC=%SQL_EXEC% SELECT ISNULL(@RowsAffected,0) RowsAffected

@REM CALL SQLCMD -Q "exit( %SQL_EXEC% )" /b /S %Server% /d %DB% > %
ResultsFile% 

CALL OSQL -Q "exit( %SQL_EXEC% )" -S%Server% -d%DB% -E -b > %ResultsFile% 

@REM This outputs info from the file to the screen
FOR /f "tokens=1* delims=*" %%i in (%ResultsFile%) do (echo %%i) 

@REM This appends info the file
FOR /f "tokens=1* delims=*" %%i in (%ResultsFile%) do (echo %%i) >> %LogFile%

PAUSE
@REM ***************************************************

IF OBJECT_ID('dbo.TestSQLCMDTab') IS NOT NULL
BEGIN
	DROP TABLE dbo.TestSQLCMDTab;
END
GO
IF OBJECT_ID('dbo.TestSQLCMDSP') IS NOT NULL
BEGIN 
	DROP PROCEDURE dbo.TestSQLCMDSP;
END
CREATE TABLE dbo.TestSQLCMDTab(Col1 int NOT NULL, Col2 int NOT NULL);
GO
INSERT dbo.TestSQLCMDTab(Col1,Col2)
SELECT 100,100
GO
CREATE PROCEDURE dbo.TestSQLCMDSP @Col1 int, @Col2 int, @RowsAffected int OUTPUT
AS
BEGIN
	BEGIN TRY
	
		DECLARE @ErrMsg nvarchar(2048);
		
		IF @Col1 = @Col2
		BEGIN
			INSERT dbo.TestSQLCMDTab(Col1,Col2)
			SELECT @Col1,@Col2;	
			SET @RowsAffected = @@ROWCOUNT;
		END
			
	END TRY
	BEGIN CATCH
		SET @ErrMsg = ERROR_MESSAGE();
		RAISERROR(@ErrMsg,16,1);
	END CATCH
END
GO