XML Error message: Name cannot begin with the '.' character, hexadecimal value 0x2E

**iburyak** · Apr 12 '07, 05:20 PM

At least you have to show your query to have any opinion on it.... :)

**JimN1** · Apr 12 '07, 05:34 PM

I keep trying to enter my query but this site keeps giving me an error saying that my messag is too short! My query is pretty large. What am I doing wrong?

**iburyak** · Apr 12 '07, 05:48 PM

It should be longer then 10 characters as far as I know.

Put whole query hope it would be easier to solve.
Are you sure you know which line gives you a problem?

I sometimes have problems like you just close IE and get back again.

**JimN1** · Apr 12 '07, 06:40 PM

Originally posted by iburyak

It should be longer then 10 characters as far as I know.

Put whole query hope it would be easier to solve.
Are you sure you know which line gives you a problem?

I sometimes have problems like you just close IE and get back again.

Hi,
I have tried several times to send the query but the site gives me an error saying I need to include the title and message. I think it may be due to the size of my query (it is big). The query works if I take out the XML Explicit line. Unfortnately, I need it to produce XML Explicit.
Sorry, I could not send it. Thanks for offering but I will have to try something else.

**iburyak** · Apr 12 '07, 07:16 PM

Split it in parts and submit several times.
Just mark Part1, Part2

**JimN1** · Apr 16 '07, 02:43 PM

Originally posted by iburyak

Split it in parts and submit several times.
Just mark Part1, Part2

[Quote=jimn1]I think it has something to do with size of the data being retrieved and formatted into XML. I cut down the number of fields being returned and it works. However, I need to retrieve all my data at once so I can create a schema for biztalk. The error message says: Unable to show XML. The following error happened:
Name cannot begin with the '.' character, hexadecimal value 0x2E. Line 1, position 37111.

One solution is to increase the number of characters retrieved from the server for XML data. To change this setting, on the Tools menu, click Options.[/ Do you know which setting to change under the Options? {/Quote]

**JimN1** · Apr 16 '07, 03:10 PM

Ok, here is part 1 of the query.

Code:

CREATE PROCEDURE [Remit].[proc_ED210_CPDE_0001_GetXMLExplicit]
AS
BEGIN
   SELECT
       Remit.Remit_Status.Rmt_Status_Id           
      ,Remit.Remit_Status.Rmt_File_Id             
      ,Remit.Remit_Status.Rmt_Chk_Nbr 
      ,Remit.Remit_Status.Rmt_Status_835         
      ,Remit.Remit_Status.Rmt_Status_EOB         
      ,Remit.Remit_Status.Rmt_Status_EOP         
      ,Remit.Remit_Status.Rmt_Status_Check_Status
      ,Remit.Remit_Status.Rmt_Status_Check_Format
      ,Remit.Remit_Status.Rmt_Status_AboveHealth 
      ,Remit.Remit_Status.Rmt_Run_Id             
      ,Remit.Remit_Host_File.Rmt_Host_Remit_Id    
      ,Remit.Remit_Host_File.Rmt_Host_File_Name
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Date          
	  ,Remit.Remit_Host_File.Rmt_Host_Begin_Time          
	  ,Remit.Remit_Host_File.Rmt_Host_End_Time            
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Num_Recs      
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Tot_Clm       
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Tot_Clm_Amt   
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Tot_Clm_Rvr   
	  ,Remit.Remit_Host_File.Rmt_Host_Remit_Tot_Clm_Rvr_Amt
                    INTO Remit.tmp_Status_Host 
	FROM Remit.Remit_Status                                              
      LEFT OUTER JOIN Remit.Remit_Host_File 
                   ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_Host_File.Rmt_File_Id 
                WHERE (Remit.Remit_Status.Rmt_Status_835 = 'Y') 
   SELECT
       Remit.Remit_HDR.Rmt_Hdr_Id                     
      ,Remit.Remit_HDR.Rmt_File_Id                    
      ,Remit.Remit_HDR.Rmt_Hdr_RecSeq                 
      ,Remit.Remit_HDR.Rmt_Hdr_Tp_Id
     ,Remit.Remit_HDR.Rmt_Hdr_Trace_Num
      ,Remit.Remit_HDR.Rmt_Chk_Num
	  ,Remit.Remit_HDR.Rmt_Chk_Date
	  ,Remit.Remit_HDR.Rmt_Hdr_Payor_Id
	  ,Remit.Remit_HDR.Rmt_Hdr_In_File_Name   
	  ,Remit.Remit_HDR.Rmt_Hdr_In_File_Date   
	  ,Remit.Remit_HDR.Rmt_Hdr_Out_File_Name  
	  ,Remit.Remit_HDR.Rmt_Hdr_Out_File_Date  
	  ,Remit.Remit_HDR.Rmt_Hdr_Run_Id         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Who_Code 
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Who_Id   
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Bank_Code
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Key      
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Txn_Cd     
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Prv_Pay_Amt
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Flag       
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Pay_Meth_Cd
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Pay_Nrm_Cd 
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Rec_Dfi_Q     
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Rec_Dfi_Id    
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Rec_Act_Num_Q 
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Rec_Act_Num   
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Org_Payer_Id  
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Org_Supp_Cd   
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Snd_Dfi_Q     
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Snd_Dfi_Id    
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Snd_Act_Num_Q 
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Snd_Act_Num   
	  ,Remit.Remit_HDR.Rmt_Hdr_Bpr_Chk_Date      
	  ,Remit.Remit_HDR.Rmt_Hdr_Trn_Type_Cd       
	  ,Remit.Remit_HDR.Rmt_Hdr_Trn_Trc_Num       
	  ,Remit.Remit_HDR.Rmt_Hdr_Trn_Org_Comp_Id   
	  ,Remit.Remit_HDR.Rmt_Hdr_Trn_Org_Ref_Id    
	  ,Remit.Remit_HDR.Rmt_Hdr_Cur_Ent_Id_Cd     
	  ,Remit.Remit_HDR.Rmt_Hdr_Cur_Code          
	  ,Remit.Remit_HDR.Rmt_Hdr_Cur_Ex_Rate       
	  ,Remit.Remit_HDR.Rmt_Hdr_Rec_Id_Q          
	  ,Remit.Remit_HDR.Rmt_Hdr_Rec_Id            
	  ,Remit.Remit_HDR.Rmt_Hdr_Ver_Id_Q          
	  ,Remit.Remit_HDR.Rmt_Hdr_Ver_Id            
	  ,Remit.Remit_HDR.Rmt_Hdr_Prod_Date_Q       
	  ,Remit.Remit_HDR.Rmt_Hdr_Prod_Date         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Ent_Id_Cd     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Name          
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Id_Cd_Q            As  Rmt_Hdr_Payer_IQ    
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Id_Cd              As  Rmt_Hdr_Payer_IdCd      
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Addr1         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Addr2         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_City          
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_St            
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Zip           
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id_Q1     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id1       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id_Q2     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id2       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id_Q3     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id3       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id_Q4     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Add_Id4       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Num_Cd   
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Name     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num_Q1
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num1 
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num_Q2
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num2 
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num_Q3
	  ,Remit.Remit_HDR.Rmt_Hdr_Payer_Cont_Com_Num3 
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Ent_Id_Cde    
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Name          
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Id_Cd_Q       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Id_Cd         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Addr1         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Addr2         
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_City          
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_St            
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Zip           
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Country       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id_Q1     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id1       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id_Q2     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id2       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id_Q3     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id3       
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id_Q4     
	  ,Remit.Remit_HDR.Rmt_Hdr_Payee_Add_Id4       
      ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Id                
      ,Remit.Remit_HDR_SUM.Rmt_RecSeq 
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Payee_key       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Assgn_Num       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Prov_Id         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Fac_Type_Cd     
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Fis_Per_Date    
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Clm_Cnt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Clm_Amt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Cov_Amt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Noncov_Amt      
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Deny_Amt        
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Prov_Amt        
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Int_Amt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Cont_Adj_Amt    
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Gr_Red_Amt      
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Msp_Amt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Bld_Ded_Amt     
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Nl_Amt          
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Coinsr_Amt      
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Hcpcs_Reprt_Amt 
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Hcpcs_Pay_Amt   
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Ded_Amt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Prf_Com_Amt     
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Msp_Met_Amt     
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Pat_Reimbrs_Amt 
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Pip_Cnt         
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Pip_Adj_Amt   
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Drg_Amt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Ned_Spec_Amt  
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Hosp_Spec_Amt 
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Shr_Amt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Sum_Cap_Amt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Med_Edu_Amt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Out_Day_Cnt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Out_Day_Amt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Out_Cost_Amt      
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Drg_Qty           
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Dischrg_Cnt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Rpt_Day_Cnt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Cov_Day_Cnt       
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Noncov_Day_Cnt    
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Msp_Pass_Amt      
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Drg_Wegt          
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Pps_Nsp_Drg_Amt   
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Pps_Hsp_Drg_Amt   
	  ,Remit.Remit_HDR_SUM.Rmt_Hdr_Pps_Dsh_Drg_Amt   
      ,Remit.Remit_PLB.Rmt_Pa_Id
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Prov_Id           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Date              
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd1       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id1           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Amt_Used          
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd2       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id2           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_NegBal_Amt_Used   
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd3       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id3           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Negadj_Amt_Used   
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd4       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id4           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Interest_Amt_Used 
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd5       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id5           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Amt5          
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Rea_Cd6       
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Ref_Id6           
	  ,Remit.Remit_PLB.Rmt_PLB_Pa_Adj_Amt6          
            INTO Remit.tmp_Hdr_Sum_PLB 
            FROM Remit.Remit_Status  
      INNER JOIN Remit.Remit_HDR
              ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_HDR.Rmt_File_Id
      INNER JOIN Remit.Remit_HDR_SUM 
              ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_HDR_SUM.Rmt_File_Id
      LEFT OUTER JOIN Remit.Remit_PLB 
              ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_PLB.Rmt_Trace_Num 
           WHERE (Remit.Remit_Status.Rmt_Status_835 = 'Y')

**JimN1** · Apr 16 '07, 03:11 PM

Originally posted by iburyak

Split it in parts and submit several times.
Just mark Part1, Part2

Here is Part 2.

Code:

                
   SELECT      
       Remit.Remit_CLM.Rmt_Clm_Id          
      ,Remit.Remit_CLM.Rmt_File_Id        
      ,Remit.Remit_CLM.Rmt_Clm_Hdr_Parent
      ,Remit.Remit_CLM.Rmt_Trace_Num     
      ,Remit.Remit_CLM.Rmt_Clm_Num 
	  ,Remit.Remit_CLM.Rmt_Chk_Num             
	  ,Remit.Remit_CLM.Rmt_Clm_Prov_Id         
	  ,Remit.Remit_CLM.Rmt_Host_Resolution     
	  ,Remit.Remit_CLM.Rmt_Host_Clm_Type       
	  ,Remit.Remit_CLM.Rmt_Host_Hdr_Resolution 
	  ,Remit.Remit_CLM.Rmt_Host_Reversal_Ind   
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Cntrl_Num   
	  ,Remit.Remit_CLM.Rmt_Clm_Stat_Cd         
	  ,Remit.Remit_CLM.Rmt_Clm_Tot_Chrg_Amt    
	  ,Remit.Remit_CLM.Rmt_Clm_Tot_Pay_Amt     
	  ,Remit.Remit_CLM.Rmt_Clm_Tot_Pat_Resp_Amt
	  ,Remit.Remit_CLM.Rmt_Clm_File_Ind_Cd     
	  ,Remit.Remit_CLM.Rmt_Clm_Cntrl_Num       
	  ,Remit.Remit_CLM.Rmt_Clm_Fac_Type_Cd     
	  ,Remit.Remit_CLM.Rmt_Clm_Freq_Type_Cd    
	  ,Remit.Remit_CLM.Rmt_Clm_Drg_Cd          
	  ,Remit.Remit_CLM.Rmt_Clm_Drg_Wegt        
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Ent_Cd      
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Ent_Type_Q  
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Lname       
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Fname       
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Mname       
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Suf_Name    
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Id_Cd_Q     
	  ,Remit.Remit_CLM.Rmt_Clm_Pat_Id           
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Ent_Cd       
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Ent_Type_Q   
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Lname        
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Fname        
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Mname        
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Suf_Name     
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Id_Cd_Q      
	  ,Remit.Remit_CLM.Rmt_Clm_Ins_Id_Cd        
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Ent_Cd   
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Ent_Q    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Lname    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Fname    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Mname    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Suf_Name 
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Id_Cd_Q  
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pat_Cd_Ind   
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Ent_Id_Cd     
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Ent_Type_Q    
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Lname         
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Fname         
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Mname         
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Suf_Name      
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Id_Cd_Q       
	  ,Remit.Remit_CLM.Rmt_Clm_Sp_Id_Cd            
	  ,Remit.Remit_CLM.Rmt_Clm_Co_Ent_Id_Cd        
	  ,Remit.Remit_CLM.Rmt_Clm_Co_Ent_Type_Q       
	  ,Remit.Remit_CLM.Rmt_Clm_Co_Ent_Lname        
	  ,Remit.Remit_CLM.Rmt_Clm_Co_Id_Cd_Q          
	  ,Remit.Remit_CLM.Rmt_Clm_Co_Id_Cd            
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Ent_Id_Cd1  
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Ent_Type_Q1 
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Lname1      
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Id_Cd_Q1    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Id_Cd1      
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Ent_Id_Cd2  
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Ent_Type_Q2 
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Lname2      
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Id_Cd_Q2    
	  ,Remit.Remit_CLM.Rmt_Clm_Cor_Pay_Id_Cd2      
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Cov_Cnt         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Amt         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Psych_Cnt       
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Drg_Amt         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Rem_Cd1         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Disp_Clm_Amt    
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Msp_Amt         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Cap_Amt     
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Fsp_Drg_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Hsp_Drg_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Dsh_Drg_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Old_Cap_Amt     
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Ime_Amt     
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Hosp_Drg_Amt
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Cost_Day_Cnt    
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Ned_Drg_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Out_Amt     
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Ind_Teach_Amt   
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Nonpay_Prof_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Rem_Cd2         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Rem_Cd3         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Rem_Cd4         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Rem_Cd5         
	  ,Remit.Remit_CLM.Rmt_Clm_Mia_Pps_Except_Amt  
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Reimbrs_Rate    
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Hcpcs_Pay_Amt   
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Rem_Cd1         
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Rem_Cd2         
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Rem_Cd3         
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Rem_Cd4         
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Rem_Cd5         
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Esrd_Amt        
	  ,Remit.Remit_CLM.Rmt_Clm_Moa_Nonpay_Prof_Amt 
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id_Q1           
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id1             
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id_Q2           
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id2             
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id_Q3           
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id3             
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id_Q4           
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id4             
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id_Q5           
	  ,Remit.Remit_CLM.Rmt_Clm_Oth_Id5             
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q1            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id1              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q2            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id2              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q3            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id3              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q4            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id4              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q5            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id5              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q6            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id6              
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q7            
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id7       
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q8     
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id8       
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q9     
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id9       
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id_Q10    
	  ,Remit.Remit_CLM.Rmt_Clm_Rp_Id10      
	  ,Remit.Remit_CLM.Rmt_Clm_Date_Q1      
	  ,Remit.Remit_CLM.Rmt_Clm_Date1        
	  ,Remit.Remit_CLM.Rmt_Clm_Date_Q2      
	  ,Remit.Remit_CLM.Rmt_Clm_Date2        
	  ,Remit.Remit_CLM.Rmt_Clm_Date_Q3      
	  ,Remit.Remit_CLM.Rmt_Clm_Date3        
	  ,Remit.Remit_CLM.Rmt_Clm_Date_Q4      
	  ,Remit.Remit_CLM.Rmt_Clm_Date4        
	  ,Remit.Remit_CLM.Rmt_Clm_Cont_Nun_Cd  
	  ,Remit.Remit_CLM.Rmt_Clm_Cont_Name    
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num_Q1   
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num1     
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num_Q2   
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num2     
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num_Q3   
	  ,Remit.Remit_CLM.Rmt_Clm_Com_Num3     
      ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Id
      ,Remit.Remit_CLM_RVSR.Rmt_Clm_Parent  
	  ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Ind             
	  ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Tot_Chrg_Amt    
	  ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Tot_Pay_Amt     
	  ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Tot_Pat_Resp_Amt
	  ,Remit.Remit_CLM_RVSR.Rmt_Clm_Rvsr_Clm_Stat_Cd     
                 INTO Remit.tmp_Clm_Rvsr 
                 FROM Remit.Remit_Status  
           INNER JOIN Remit.Remit_Clm
                   ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_Clm.Rmt_Trace_Num
      LEFT OUTER JOIN Remit.Remit_Clm_RVSR
                   ON Remit.Remit_Status.Rmt_File_Id = Remit.Remit_Clm_RVSR.Rmt_Trace_Num AND
                      Remit.Remit_CLM.Rmt_Clm_Hdr_Parent = Remit.Remit_CLM_RVSR.Rmt_Clm_Parent
                WHERE (Remit.Remit_Status.Rmt_Status_835 = 'Y')

**iburyak** · Apr 16 '07, 03:34 PM

Where is For XML statement here?

Which line gives you a problem?

**JimN1** · Apr 16 '07, 03:45 PM

Originally posted by iburyak

Split it in parts and submit several times.
Just mark Part1, Part2

Here is part 3 of the query where is starts getting interesting.

Code:

   SET NOCOUNT ON;
   SELECT                                                                                 
      1 AS Tag,
      NULL AS Parent,
--                  ----------  Round 1  ---------------------------
--                  ----------  Remit_Status & Remit_Host  ---------
-- !1!  Begin tmp_Status_Host           20 columns --- 
       Remit.tmp_Status_Host.Rmt_Status_Id                   AS [Remit.tmp_Status_Host!1!Rmt_Status_Id]
      ,Remit.tmp_Status_Host.Rmt_File_Id                     AS [Remit.tmp_Status_Host!1!Rmt_File_Id]
      ,Remit.tmp_Status_Host.Rmt_Chk_Nbr                     AS [Remit.tmp_Status_Host!1!Rmt_Chk_Nbr]
      ,Remit.tmp_Status_Host.Rmt_Status_835                  AS [Remit.tmp_Status_Host!1!Rmt_Status_835]
      ,Remit.tmp_Status_Host.Rmt_Status_EOB                  AS [Remit.tmp_Status_Host!1!Rmt_Status_EOB]
      ,Remit.tmp_Status_Host.Rmt_Status_EOP                  AS [Remit.tmp_Status_Host!1!Rmt_Status_EOP]
      ,Remit.tmp_Status_Host.Rmt_Status_Check_Status         AS [Remit.tmp_Status_Host!1!Rmt_Status_Check_Status]
      ,Remit.tmp_Status_Host.Rmt_Status_Check_Format         AS [Remit.tmp_Status_Host!1!Rmt_Status_Check_Format]
      ,Remit.tmp_Status_Host.Rmt_Status_AboveHealth          AS [Remit.tmp_Status_Host!1!Rmt_Status_AboveHealth]
      ,Remit.tmp_Status_Host.Rmt_Run_Id                      AS [Remit.tmp_Status_Host!1!Rmt_Run_Id]
      ,Remit.tmp_Status_Host.Rmt_Host_Remit_Id               AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Id]
      ,Remit.tmp_Status_Host.Rmt_Host_File_Name              AS [Remit.tmp_Status_Host!1!Rmt_Host_File_Name]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Date             AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Date]
	  ,Remit.tmp_Status_Host.Rmt_Host_Begin_Time             AS [Remit.tmp_Status_Host!1!Rmt_Host_Begin_Time]
	  ,Remit.tmp_Status_Host.Rmt_Host_End_Time               AS [Remit.tmp_Status_Host!1!Rmt_Host_End_Time]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Num_Recs         AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Num_Recs]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Tot_Clm          AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Tot_Clm]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Tot_Clm_Amt      AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Tot_Clm_Amt]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Tot_Clm_Rvr      AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Tot_Clm_Rvr]
	  ,Remit.tmp_Status_Host.Rmt_Host_Remit_Tot_Clm_Rvr_Amt  AS [Remit.tmp_Status_Host!1!Rmt_Host_Remit_Tot_Clm_Rvr_Amt]
--    End Remit.tmp_Status_Host           
-- !2!  Begin   tmp_Hdr_Sum_PLB      157 Columns ---
      ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Id]                     
      ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_File_Id]                    
      ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_RecSeq]                 
      ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Tp_Id]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Trace_Num]
      ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Chk_Num] 
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Chk_Date]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Payor_Id]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_In_File_Name]   
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_In_File_Date]   
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Out_File_Name]  
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Out_File_Date]  
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Run_Id]         
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Payee_Who_Code] 
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Payee_Who_Id]   
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Payee_Bank_Code]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Payee_Key]      
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Txn_Cd]     
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Prv_Pay_Amt]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Flag]       
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Pay_Meth_Cd]
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Pay_Nrm_Cd] 
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Rec_Dfi_Q]     
	  ,NULL                                            AS [Remit.tmp_Hdr_Sum_PLB!2!Rmt_Hdr_Bpr_Rec_Dfi_Id]

**JimN1** · Apr 16 '07, 03:54 PM

The 'UNION ALL' s appear to be too big to submit. I am having trouble sending them. Even trying to break them up into smaller pieces.
Here is part 4.
[

**iburyak** · Apr 16 '07, 04:24 PM

OK I think I got it.

In line below:

Code:

[Remit.tmp_Status_Host!1!Rmt_Status_Id]

This part Remit.tmp_Statu s_Host is a name of a future tag in XML.

You can't have a tag like this:

Code:

<Remit.tmp_Status_Host> </Remit.tmp_Status_Host>

it should be like below or any name you want to give to a tag but not with a period inside:

Code:

<tmp_Status_Host> </tmp_Status_Host>

[PHP]
-- This Line
[Remit.tmp_Statu s_Host!1!Rmt_St atus_Id]

-- should be changed to something like this
[tmp_Status_Host !1!Rmt_Status_I d][/PHP]

Good Luck.

**JimN1** · Apr 16 '07, 05:39 PM

Your are Good!
That was it. I took the database qualifier (Remit.) off and it works!
You have really helped.
Thanks A lot.

Jim

**iburyak** · Apr 16 '07, 06:33 PM

Your code is difficult to read. It looks like it is written in auto generated utility in Access.

1. You don’t need to prefix each object with database name if statement executed in the same database.
2. Use aliases to make code more readable.
3. Forget ACCESS…. :)

I would change this:
[PHP]
Select Remit.Remit_CLM .Rmt_Clm_Com_Nu m3
,Remit.Remit_CL M_RVSR.Rmt_Clm_ Rvsr_Id
INTO Remit.tmp_Clm_R vsr
FROM Remit.Remit_Sta tus
INNER JOIN Remit.Remit_Clm
ON Remit.Remit_Sta tus.Rmt_File_Id = Remit.Remit_Clm .Rmt_Trace_Num
LEFT OUTER JOIN Remit.Remit_Clm _RVSR
ON Remit.Remit_Sta tus.Rmt_File_Id = Remit.Remit_Clm _RVSR.Rmt_Trace _Num AND
Remit.Remit_CLM .Rmt_Clm_Hdr_Pa rent = Remit.Remit_CLM _RVSR.Rmt_Clm_P arent
WHERE (Remit.Remit_St atus.Rmt_Status _835 = 'Y') [/PHP]
To this:
[PHP]
Select c.Rmt_Clm_Com_N um3
,r.Rmt_Clm_Rvsr _Id
INTO Remit.tmp_Clm_R vsr
FROM Remit_Status s
INNER JOIN Remit_Clm c
ON s.Rmt_File_Id = c.Rmt_Trace_Num
LEFT OUTER JOIN Remit_Clm_RVSR r
ON s.Rmt_File_Id = r.Rmt_Trace_Num AND c.Rmt_Clm_Hdr_P arent = r.Rmt_Clm_Paren t
WHERE s.Rmt_Status_83 5 = 'Y'[/PHP]

Good Luck.

XML Error message: Name cannot begin with the '.' character, hexadecimal value 0x2E

XML Error message: Name cannot begin with the '.' character, hexadecimal value 0x2E

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment