question

I am new to SSMS and need to export this query with the column names included. CREATE PROCEDURE [dbo].[sp_IEHP_FACESHEETTEST] @StartDate DATETIME = Null, @EndDate DATETIME = Null AS DECLARE @StartStr VARCHAR(23),@EndStr VARCHAR(23), @RptStart DATETIME,@RptEnd DATETIME, @UseDate DATETIME, @FileName VARCHAR (18), @Command VARCHAR(250), @FileLoc VARCHAR(50) --,@ID VARCHAR (50) SET @UseDate = GETDATE() IF @StartDate IS NULL AND @EndDate IS NULL BEGIN SET @StartDate = GETDATE ()-1 SET @EndDate = GETDATE ()-1 SET @StartStr = Convert(varchar(2),DatePart(MONTH,@StartDate))+'/'+ Convert(varchar(2),DatePart(DAY,@StartDate))+'/'+ Convert(varchar(4),DatePart(YYYY,@StartDate))+' '+ '00:00:00.000' SET @EndStr = Convert(varchar(2),DatePart(MONTH,@EndDate))+'/'+ Convert(varchar(2),DatePart(DAY,@EndDate))+'/'+ Convert(varchar(4),DatePart(YYYY,@EndDate))+' '+ '23:59:59.990' SET @StartDate = Convert(datetime,@StartStr) SET @EndDate = Convert(datetime,@EndStr) END SET @FileName = Convert(varchar(2),DatePart(MONTH,@UseDate))+ Convert(varchar(2),DatePart(DAY,@UseDate))+ Convert(varchar(4),DatePart(YYYY,@UseDate)) --SET @ID = +1 SET @FileLoc = '\\sangorbandc02\z$\IEHP-Staging' SET @Command = 'bcp "Select * from SGMH_Reports.dbo.FACESHEET" queryout "'+ RTRIM(LTRIM(@FileLoc))+'\ProviderID_Facesheet_'+@FileName+'.txt" -T -c -t^|' SELECT DISTINCT [CONTROL_ID] = '15'+'_'+TPM300.vst_ext_id, [MEMBER EXT_ID_auth] = LEFT(paragon_rpt.dbo.fn_get_policy_num(TPM300.vst_int_id,1),12), [EFFECTIVE_DATE_auth] = CONVERT(VARCHAR,TPM300.adm_ts,101), [PROVIDER_EXT_ID_auth] = '15', [DISCHARGE_DIAGNOSIS_auth] = '', [DISCHARGE_DATE_auth] = '', [DISCHARGE_DISPOSITION_ID_auth] = '', [PRIMARY_DIAGNOSIS_CODE_diag] = '', [POA_ID_1_diag] = '', [DIAGNOSIS_CODE_2_diag] = '', [POA_ID_2_diag] = '', [DIAGNOSIS_CODE_3_diag] = '', [POA_ID_3_diag] = '', [DIAGNOSIS_CODE_4_diag] = '', [POA_ID_4_diag] = '', [DIAGNOSIS_CODE_5_diag] = '', [POA_ID_5_diag] = '', [ROOM_RECORD_NUMBER_revw] = TPM300.med_rec_no, [PLACE_OF_SERVICES_ID_revw] = ISNULL(paragon_rpt.dbo.fn_get_cod_ds(TSM925.plc_srv_cd),''), [BED_TYPE_days] = CASE WHEN TSM950.loc_ds = 'MS' THEN 'Medical/Surgical' WHEN TSM950.loc_ds = 'OB' THEN 'Obstetrics' WHEN TSM950.loc_ds = 'NSY' THEN 'Nursery' WHEN TSM950.loc_ds in ('ICU1','ICU2') THEN 'ICU' ELSE TSM950.loc_ds END, [COMMENTS_notes] = ISNULL(TPM300.adm_diag_note,'') INTO FACESHEET FROM paragon_rpt.dbo.TPM300_PAT_VISIT TPM300 LEFT OUTER JOIN paragon_rpt.dbo.TSM040_PERSON_HDR TSM040 ON TPM300.psn_int_id = TSM040.psn_int_id LEFT OUTER JOIN paragon_rpt.dbo.TPM311_VISIT_PAYOR TPM311 ON TPM311.vst_int_id = TPM300.vst_int_id LEFT OUTER JOIN paragon_rpt.dbo.TSM950_LOCATION_REF TSM950 ON TSM950.loc_int_id = TPM300.loc_lvl_3_id LEFT OUTER JOIN paragon_rpt.dbo.TSM925_PAT_CAT_TYPE TSM925 ON TPM300.pat_cat_cd = TSM925.pat_cat_cd WHERE TPM300.adm_ts BETWEEN @StartDate AND @EndDate AND paragon_rpt.dbo.fn_get_payor_name(TPM300.vst_int_id,1) like 'INLAND EMPIRE HEALTH PLAN' AND TPM300.pat_cat_cd = '4760' --INPATIENT and TSM925.plc_srv_cd = '24947' --Inpatient Hospital SELECT * FROM FACESHEET print @Command EXEC xp_cmdshell @Command DROP TABLE FACESHEET