Member Avatar for hhaannyy 
            cmd = New SqlCommand("INSERT INTO temp_balance ( debit, credit, accname ) SELECT Sum(temp_sheet.debit) AS debit, Sum(temp_sheet.credit) AS credit, IIf (debit < credit ,'loss','profit') AS expr1 FROM temp_sheet group by temp_sheet.debit,temp_sheet.credit ;", con)

there an error i dont know the error incorrect syntax near ' )

  • 2 Contributors
  • 2 Replies
  • 201 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by hhaannyy
Member Avatar for RudyM

Can you run the select separately? And same with insert, using test values? Then try the whole sql statement in SSMS. Nothing stands out as obvious error with syntax.

Member Avatar for hhaannyy

thank you

Be a part of the DaniWeb community

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