WHILE(@MIN <= @MAX)
BEGIN
		
		
		SELECT @HFFolderName=HFFolderName,@ExecFileName=ExecFileName FROM [dbo].[HFDetails] WHERE ID=@MIN
		
		SET @Sqlcmd='SQLCMD -E -b -S '+@ServerName+' -d '+@EngagementDb+ ' -i "'+@currentdirectory+'Database scripts\'+@HFFolderName+'\'+@ExecFileName+'"'

		SET @SQLString2 ='exec @Ret=master.dbo.xp_cmdshell '
		SET @SQLString2=@SQLString2+''''+@Sqlcmd+''''
		
		INSERT INTO @tempError
		EXEC sp_executesql @SQLString2,@ParmDefinition,@Ret=@OutRet OUTPUT

		
		IF @OutRet=0 
		BEGIN
			SET @TimeStamp=CONVERT(NVARCHAR(25),GETDATE(),121)
						
			UPDATE E1.EngagementDBInstallationDetails SET Installed=1,InstallationEndTime=GETDATE() 
						WHERE InstallationName=@HFFolderName AND FileName=@ExecFileName
			
			PRINT @TimeStamp+' : Successfully executed Database scripts\'+@HFFolderName+'\'+@ExecFileName 
			PRINT ' '
			
		END
		ELSE
		BEGIN
			
			SET @TimeStamp=CONVERT(NVARCHAR(25),GETDATE(),121)
			
						
			SELECT @StrErr=@StrErr+CHAR(13)+CHAR(10)+Error FROM @tempError WHERE Error IS NOT NULL
			
			UPDATE E1.EngagementDBInstallationDetails SET Installed=2,InstallationEndTime=GETDATE() 
						WHERE InstallationName=@HFFolderName AND FileName=@ExecFileName
						
			PRINT @TimeStamp+' : Error while executing Database scripts\'+@HFFolderName+'\'+@ExecFileName
			PRINT ' ' 
			PRINT @StrErr
			PRINT ' '
						
			BREAK;			
		END
	
		DELETE FROM @tempError

		SET @MIN=@MIN+1

END

INSERT INTO @tempError
EXEC sp_executesql @SQLString2,@ParmDefinition,@Ret=@OutRet OUTPUT