No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
4 Posted Topics
PM312, I noticed your question and it looks like you are asking for 2 things: 1. the sum of the 'DocAmount' - that's as explained by 'pty' in the other reply. 2. you want to display other info about the 'DocNo's that you are using in the GROUP BY. This …
I'd be happy to take a look. You can contact me via [url]www.britican.com[/url]
Rob, are you using something similar to the following before you start building the XML body? Response.ContentType = "text/xml; charset=utf-8" Can you provide us with a snippet of your code? Kim
Two things: 1. the 'date'column is a reserved word so use the '[date]' syntax as previously mentioned - or a better solution is NOT to use reserved words! ;^) Sorry, forgot: you should also use the # sign around a date (instead of the single quote), thus: [code] insert into …
The End.