silent lover 0 Light Poster

COMBINATION_ACIL contains column:
id (primary)
prodcode
[group]
alias
lastupdate
updateby

and here is the steps when i import xml to sql

DECLARE @COMBINATION_ACIL AS xml
SET @COMBINATION_ACIL = '
<Product>

  <product>

    <PRODCODE>CADB</PRODCODE>

    <GROUP>CADB</GROUP>

    <ALIAS>ADB</ALIAS>

  </product>

  <product>

    <PRODCODE>CI50</PRODCODE>

    <GROUP>CI50</GROUP>

    <ALIAS>I50</ALIAS>

  </product>

  <product>

    <PRODCODE>CI80</PRODCODE>

    <GROUP>CI80</GROUP>

    <ALIAS>I80</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBA</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBA</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBB</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBB</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBC</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBC</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBD</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBD</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBE</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBE</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBF</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBF</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSBG</PRODCODE>

    <GROUP>HOSB</GROUP>

    <ALIAS>HOSBG</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSPA</PRODCODE>

    <GROUP>HOSP</GROUP>

    <ALIAS>HOSPA</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSPB</PRODCODE>

    <GROUP>HOSP</GROUP>

    <ALIAS>HOSPB</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSPC</PRODCODE>

    <GROUP>HOSP</GROUP>

    <ALIAS>HOSPC</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSPD</PRODCODE>

    <GROUP>HOSP</GROUP>

    <ALIAS>HOSPD</ALIAS>

  </product>

  <product>

    <PRODCODE>HOSPE</PRODCODE>

    <GROUP>HOSP</GROUP>

    <ALIAS>HOSPE</ALIAS>

  </product>

  <product>

    <PRODCODE>PW55</PRODCODE>

    <GROUP>PW</GROUP>

    <ALIAS>PW55</ALIAS>

  </product>

  <product>

    <PRODCODE>PW60</PRODCODE>

    <GROUP>PW</GROUP>

    <ALIAS>PW60</ALIAS>

  </product>

  <product>

    <PRODCODE>PW65</PRODCODE>

    <GROUP>PW</GROUP>

    <ALIAS>PW65</ALIAS>

  </product>

  <product>

    <PRODCODE>PPW18</PRODCODE>

    <GROUP>PPW</GROUP>

    <ALIAS>PPW18</ALIAS>

  </product>

  <product>

    <PRODCODE>PPW25</PRODCODE>

    <GROUP>PPW</GROUP>

    <ALIAS>PPW25</ALIAS>

  </product>

</Product>
'
INSERT INTO COMBINATION_ACIL (fileds)
SELECT  fileds.value('PRODCODE[1]', 'varchar(50)') AS prodcode,
        fileds.value('GROUP[1]', 'varchar(50)') AS [group],
        fileds.value('ALIAS[1]', 'varchar(50)') AS alias
FROM    @COMBINATION_ACIL.nodes('Product/product') as  COMBINATION_ACIL(fileds)

what is this error means?
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ')'. its error on the line of "insert into".
Did i write wrong syntax to import that xml into sql? what is the correct syntax?
thanks for your help :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.