摘要:
--测试环境MSSQL2008 --建表 Create Table M ( Id int, Name Varchar(20), PId int ) Create Table N ( Id int, DesContent Varchar(20), M_Id int, TotalMoney int ) --插入数据 Insert int... 阅读全文
摘要:
SELECT * FROM Tablewhere a.TenantKey=@TenantId AND (@ProjectKeys is null or b.RecuritProjectKey in (select * from dbo.f_SplitToInt(@ProjectKeys,',')))... 阅读全文
摘要:
select a on 0,{ [Dim Job].[Job Title].children} * {[Dim Job].[Job Id].children}* {[Dim Job].[Job Status Alias].children} on rows from [ASA Recruitment V2] 阅读全文