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_KEYCALL_DT varchar(20), 
  CALL_DISP_CD varchar(20),
  SUB_DISP_CD varchar(20)
)
;

INSERT INTO ##Test
    (ELID_KEYCALL_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