22,209
社区成员
发帖
与我相关
我的任务
分享
;WITH ArbitratorInfo(NamePinYin,CurrentStatus) AS (
SELECT 'Ali','Y' UNION ALL
SELECT 'Bob','Y' UNION ALL
SELECT 'ZeDong','Y'
)
SELECT sv.number,char(sv.number) as alph ,ai.NamePinYin
FROM master.dbo.spt_values as sv
LEFT JOIN ArbitratorInfo AS ai ON LEFT(UPPER(ai.NamePinYin),1)=CHAR(sv.number) AND CurrentStatus='Y'
WHERE sv.type='P'
AND sv.number between ascii('A') and ascii('Z')