September 15, 2010 at 4:06 am
Dear Friends,
One of our customers would like to get their invoice data from Web Service in XML format...Could you pls help me about the steps ?...Thinking that I'm, only, able to create a new project for Web Service using Visul Studio and write related T-SQL codes...Sample scenerio :
1- Customer login to Web Service.
2- Customer enters/selects parameter (Date or Invoice No) of the invoice.
3- A button is activated/enabled and by clicking on it customer gets the XML file..
Thanks in advance....
September 15, 2010 at 4:32 am
Dear Muratingol, please provide some sample data and the table structures so that we will give you what exactly you want!
October 11, 2010 at 5:03 am
HERE IS THE QUERY :
Select cust_code as CUSTOMER_ID, cust_inv_date as ISSUE_DATE, cust_inv_amount as AMOUNT, cust_inv_no as INVOICE_NO from dbo.cust_inv_issued where cust_code = 'MICROSOFT' and
day(cust_inv_date )>= 01 and MONTH(cust_inv_date )= 10 and day(cust_inv_date)<= 03 and MONTH(cust_inv_date )= 10
AND THE RESULT IS
CUSTOMER_IDISSUE_DATE AMOUNT INVOICE_NO
MICROSOFT2010-10-01 00:00:00.000140,407184784882187640
MICROSOFT2010-10-01 00:00:00.0005,93999999761581187670
MICROSOFT2010-10-01 00:00:00.00028,1430006027222187754
MICROSOFT2010-10-01 00:00:00.0002,47800000473857187799
MICROSOFT2010-10-02 00:00:00.00014,8680005073547187925
MICROSOFT2010-10-02 00:00:00.000536,481111069322187952
MICROSOFT2010-10-02 00:00:00.0001274,27061145274187970
MICROSOFT2010-10-02 00:00:00.000595,728021931966187983
MICROSOFT2010-10-02 00:00:00.00036,249602186415188021
MICROSOFT2010-10-02 00:00:00.000586,67719294548188023
MICROSOFT2010-10-02 00:00:00.0001037,49959507585188043
MICROSOFT2010-10-03 00:00:00.000114,047998428345188088
THNX A LOT IN ADVANCE 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply