LEFT(TNAME,CHARINDEX(’.’,TNAME)-1) 取.前面的值
SUBSTRING(TNAME,1,CHARINDEX(’.’,TNAME) - 1)取.前面的值
reverse倒置函数,取最后一个/后的值
问题:传递给 LEFT 或 SUBSTRING 函数的长度参数无效。
SELECT SUBSTRING(TNAME,1,CHARINDEX('.',TNAME) - 1) AS NAME,count(1) AS NUM
FROM (
SELECT reverse(SUBSTRING(reverse(TNAME),1,CHARINDEX('/',reverse(TNAME)) - 1)) AS TNAME
from finelogdb.dbo.FINE_RECORD_EXECUTE
WHERE tname LIKE '%人力资源%'
) T