Re: Help with SQL statement

Just for the sake of interest, I think that this would have solved Jay's 
problem as well:

WITH grouped AS (SELECT <fields>
                 FROM   <file>
                 JOIN   <other file> on <join criteria>
                 GROUP BY <fields>)

SELECT COUNT(*)
FROM   grouped


First of all, does that make sense (I didn't test it).  Secondly, are CTEs 
more efficient that the combination of CONCAT and DIGITS?



#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################