Comments by Kabi Pr. Sahoo

Kabi Pr. Sahoo 15-Apr-14 9:20am View

Clarify your question...

Kabi Pr. Sahoo 15-Apr-14 6:40am View

This is your query...Just check it..
SELECT upplier,tbl_purchaseOrders.Purchase Order No,Date Ordered,
Due Date,Terms of Payment,
case when Invoice Date <= Due date
then 'Delivered'
else
case when Invoice Date >= Due Date
then 'Late Delivery'
else
case when Due Date <= CONVERT(VARCHAR,GETDATE(),110)
then 'on due'
end
end
end
as Status from tbl_invoice,tbl_purchaseOrders

Kabi Pr. Sahoo 14-Apr-14 6:22am View

welcome...

Kabi Pr. Sahoo 14-Apr-14 0:22am View

Thanks tadit..for the info.

Kabi Pr. Sahoo 11-Apr-14 6:05am View

Can you Please briefly describe about http://jsfiddle.net/[^]?

Comments by Kabi Pr. Sahoo (Top 5 by date)