@echo off
echo Running Export 
sqlcmd -S .\SPSQL  -d alliance8300 -E -Q "SELECT PersonId, FirstName, LastName, MiddleName1, MiddleName2, Initials, EmployeeNumber, TcProfileId, PersonNo, CARD.CardNo, CARD.sitecode FROM [Alliance8300].[dbo].[PersonTable] PERSON INNER JOIN [Alliance8300].[dbo].[TcCardTable] CARD ON CARD.PersonId = PERSON.Id WHERE CARD.Status = 1" -s "," -o "c:\temp\SC_export.csv"
if not errorlevel 1 goto next1  
echo == An error occurred
:next1
echo DONE
echo --FILE-- c:\temp\SC_export.csv
:exit