RE: SELECT short date
Perhaps I was not clear, let me post the code. CREATE VIEW dbo.vwImport AS SELECT dbo.tblSHOrderItems.dteShipped, dbo.tblSHOrderItems.txtInvNum, dbo.tblSHOrderItems.txtSuffix, dbo.tblSHOrdHead.txtCustomerPO, SUM(dbo.tblSHOrderItems.intQuantity * dbo.tblSHOrderItems.curPrice) AS subtotal, dbo.tblSHOrdHead.curTaxAmt, dbo.tblSHOrdHead.pk, SUM(dbo.tblSHOrderItems.intQuantity * dbo.tblSHOrderItems.curPrice) + dbo.tblSHOrdHead.curTaxAmt + dbo.tblSHOrdHead.curFreight AS grandtotal, dbo.tblSHOrdHead.curFreight, dbo.tblSHOrdHead.txtCustnum FROM dbo.tblSHOrderItems INNER JOIN dbo.tblSHOrdHead ON dbo.tblSHOrderItems.FKOrdHead = dbo.tblSHOrdHead.pk GROUP BY dbo.tblSHOrderItems.dteShipped, dbo.tblSHOrderItems.txtInvNum, dbo.tblSHOrderItems.txtSuffix, dbo.tblSHOrdHead.txtCustomerPO, dbo.tblSHOrdHead.pk, dbo.tblSHOrdHead.curTaxAmt, dbo.tblSHOrdHead.curFreight, […]
2003-06-18
1 reads