Pivot

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

CREATE TABLE #Test (
  ELID_KEY varchar(20) NOT NULL,
  CALL_DT datetime NOT NULL, 
  CALL_DISP_CD varchar(20),
  SUB_DISP_CD varchar(20)
)
;

INSERT INTO #Test
    (ELID_KEY, CALL_DT, CALL_DISP_CD, SUB_DISP_CD)
VALUES
    ('UXXXXX6', '2016-06-27', 'App in progress', NULL),
    ('UXXXXX6', '2016-06-27', 'App in progress', NULL),
    ('UXXXXX6', '2016-06-27', 'Shopping', NULL),
    ('UXXXXX6', '2018-02-05', 'App in progress', NULL),
    ('UXXXXX6', '2017-11-30', 'App in progress', NULL),
    ('UXXXXX6', '2017-07-13', 'App in progress', NULL),
    ('UXXXXX6', '2017-02-01', 'App in progress', NULL),
    ('UXXXXX7', '2018-01-15', 'Transfer', 'Customer Service')
;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results