быдло код ))
SELECT SC.SER_ID AS ID,
dbo.ConvertToLocalTime2(SC.REG_CREATED) AS Created,
dbo.ConvertToLocalTime2(SC.SER_ACTUALFINISH) AS Finish,
dbo.ConvertToLocalTime2(SC.SER_DEADLINE) AS Deadline,
CreatedBy.ACC_SHOWNAME AS Author,
cod1_ru.CDL_NAME AS Source,
cod2_ru.RCT_NAME AS Status,
SC.SER_STA_OID AS status_id,
Caller.PER_NAME AS Initiator,
ORG.ORG_NAME1 AS Department,
cod3_ru.RCT_NAME AS Category,
SC.SER_CAT_OID AS category_id,
Повернутися в гостьову
Додати коментарIgor)
4.02.13 12:08
быдло код ))
SELECT SC.SER_ID AS ID,
dbo.ConvertToLocalTime2(SC.REG_CREATED) AS Created,
dbo.ConvertToLocalTime2(SC.SER_ACTUALFINISH) AS Finish,
dbo.ConvertToLocalTime2(SC.SER_DEADLINE) AS Deadline,
CreatedBy.ACC_SHOWNAME AS Author,
cod1_ru.CDL_NAME AS Source,
cod2_ru.RCT_NAME AS Status,
SC.SER_STA_OID AS status_id,
Caller.PER_NAME AS Initiator,
ORG.ORG_NAME1 AS Department,
cod3_ru.RCT_NAME AS Category,
SC.SER_CAT_OID AS category_id,