0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

declare @dt as table(col varchar(100));
insert into @dt 
select 'ASOF_DT' union all
select 'GL_BUS_UNT_CD' union all
select 'CORP_COLLAT_CLSS_CD' union all
select 'CORP_HQLA_CD' union all
select 'GL_DEPT_ID' union all
select 'CURR_FLT_RT' union all
select 'CUSIP_ID_DC_ID' union all
select 'FR_CNTRPTY_TYPE' union all
select 'GL_GRP_CD' union all
select 'LOC_COLLAT_CLSS_CD' union all
select 'LOC_HQLA_CD' union all
select 'MTRTY_DT' union all
select 'PAR_VAL_AMT' union all
select 'PLDG_FCE_AMT_ARR' union all
select 'PLDG_TO_INST_ARR' union all
select 'PSTN_ID' union all
select 'RT_TYPE_CD' union all
select 'SRC_SYS_ID' union all
select 'SUB_INSTRMNT_TYPE' union all
select 'TRADE_DT' union all
select 'UDF_1_VAL' union all
select 'CURR_INT_RT' union all
select 'MRKT_VAL_AMT' union all
select 'STTLMNT_DT';

select stuff((select ', i.' + col from @dt
for xml path('')
), 1, 1, '');

fork query

created jan 30 anonymous