#!/bin/bash

SQLCMDSS=$( WHERE -R "c:\Program Files" SQLCMD )
readarray -t SQLCMDS <<< "${SQLCMDSS}"

for SQLCMDR in "${SQLCMDS[@]}"
do
	SQLCMD=`echo ${SQLCMDR} | sed 's/[\\n\\r]+//g'`
	if [ ! -f "${SQLCMD}" ];
	then
		echo "not found ${SQLCMD}" >&2
		continue;
	fi

	result=$( "$SQLCMD" "$@" )
	if [[ $result == *"Error"* ]] || [[ $result == *"Incorrect"* ]]; 
	then
		echo $result >&2
		exit 1
	fi

	echo "${result}" | sed 's/^M//g'
	exit 0
done