简单的查询类型转换

select (cast(left(convert(varchar,getdate(),112),4) as int) - cast(left(convert(varchar,BornTime,112),4) as int)) as old,EmployeeCode,EmployeeName,RegisterAddress,HomeAddress,NonceAddress,Sex,EmployeeType,MobilePhone,EntryTime,CertificateType,PostID,c.ChineseName,c.EnglishName  from dbo.PUB_Employee left outer join dbo.PUB_Company c on c.[ID] = dbo.PUB_Employee.CompanyID where  Sex = 0 and c.ChineseName like '%总公司%';

 begin
declare @popedomname nvarchar(2000)
declare @id int, @fatherid int;
set @popedomname = '';

select @fatherid = FatherId, @popedomname = PopedomName + ',',@id =[ID]  from PUB_Popedom where ClassName like '%EmployeeGrop%';

while @fatherid <>0
begin
select @fatherid = FatherId,@popedomname = @popedomname + PopedomName + ',' from PUB_Popedom where ID = @fatherid;
end
select left(@popedomname,len(@popedomname)-1);
end