how can i insert xml value into SQL table

Please share valid Test Query I am not getting Any result

   INSERT TABLENAME
		   (
			  OrderDate,COUNTER    // TBL COLUMNS
		   )
							  
		   SELECT 
				
					CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),112)) AS  OrderDate,			
					CASE CH.COUNTER WHEN 'A' THEN 1 END AS COUNTER
		
										
		   FROM #TEMP CH(NOLOCK) 	

Please refer below link

CREATE TABLE #TABLENAME(OrderDate DATETIME,COUNTER VARCHAR(10));
  
DECLARE @XML AS XML
SET @XML = '<main>
    <Data>
        <COUNTER>A</COUNTER>
    </Data>
	  <Data>
        <COUNTER>B</COUNTER>
    </Data>
</main>';

SELECT   
    Data.value('(/COUNTER/text())[1]','VARCHAR(100)') AS COUNTER
INTO #Temp
FROM
   @XML.nodes('/main/Data') AS AdviceData (Data);

INSERT #TABLENAME(OrderDate,COUNTER)                            
SELECT CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE(),112)) AS  OrderDate,        
	(ASCII(CH.COUNTER) - 64) AS COUNTER
FROM #TEMP CH(NOLOCK)    

SELECT * FROM #temp
SELECT * FROM #TABLENAME

DROP TABLE #Temp
DROP TABLE #TABLENAME

HI shashikant,

thanks for your reply,

i tried with your code but counter display null value.

please let me know