DoronFCG/blog_20110328_19.sql

## blog_20110328_19.sql
SELECT  -- 10 seconds
    COUNT(D1)
FROM
    #T
WHERE PATINDEX('[0-9][0-9][-][0-9][0-9][-][0-9][0-9][0-9][0-9]%',D1)=1 AND D1 <>''
	SELECT -- 10 seconds
	COUNT(D1)
	FROM
	#T
	WHERE PATINDEX('[0-9][0-9][-][0-9][0-9][-][0-9][0-9][0-9][0-9]%',D1)=1 AND D1 <>''