USE [ARSystem]
go
/****** Object: View [dbo].[ISS_HPD_WorkLogMod1] Script Date: 08/13/2013 11:06:27 ******/
SET ansi_nulls ON
go
SET quoted_identifier ON
go
ALTER VIEW [dbo].[ISS_HPD_WorkLogMod1]
AS
SELECT T1.work_log_id,
T1.submitter,
T1.submit_date,
T1.assigned_to,
T1.last_modified_by,
T1.last_modified_date,
T1.status,
T1.short_description,
T1.assignee_groups,
( CASE
WHEN ( ( T2.first_name IS NOT NULL )
AND ( T2.last_name IS NOT NULL ) ) THEN (
T2.first_name + ' ' + T2.last_name )
ELSE ( T1.submitter )
END ) AS ConcatFLName
FROM hpd_worklog AS T1
FULL OUTER JOIN ctm_people AS T2
ON T1.work_log_submitter = T2.remedy_login_id
go
Комментариев нет:
Отправить комментарий