In Crystal, I've come across the following code but don't really understand it:
I'm involved in creating equivalent reports from an old system using Crystal, into a new system with SQL Server 2005 without Crystal, so i need to understand what exactly this statement does so i can do something which produces equivalent results in SQL Server.
The fact that it repeats the same column twice inside the function's brackets is confusing me, what would this do?
It's been explained to me as being like Excel's COUNTIF statement, where it basically counts the repetitions of the column contents but surely that would produce more than 1 result and COUNT can only handle 1 result at a time?
Any help would be appreciated
Code:
COUNT ({tableName1.column1},{tableName1.column1})
The fact that it repeats the same column twice inside the function's brackets is confusing me, what would this do?
It's been explained to me as being like Excel's COUNTIF statement, where it basically counts the repetitions of the column contents but surely that would produce more than 1 result and COUNT can only handle 1 result at a time?
Any help would be appreciated
Comment