I have a table that has a column called afsTransaction
In the column can be any integer from 0 to 10000
I need a single select statement so that I get the UID, count(afsTransactions=0), count(afsTransactions <>0)
My currect (partial) select is attached.
Set @afsCount = (Select Count(*)
where substring(afsSource,4,4) = @DealID
afsTransaction <> 0)