|
BurkeJax
Starting Member
1 Post |
 Posted - 2008-07-15 : 13:54:36
|
| I am attempting to do a 3 table join with a GETDATE statement to pull items with a RECDATE greater than the previous day. It takes more than 5 minutes to complete, unless I put in a TOP string. Here is what I am attempting to run:SELECT dbo.InvAccum.INVOICE_NUMBER AS Expr18, dbo.InvAccum.RecDate AS Expr1, dbo.InvAccum.SentDate, dbo.InvAccum.Type AS Expr11, dbo.InvAccum.Status, dbo.InvAccum.Order_Number AS Expr19, dbo.InvAccum.HOLDCODE AS Expr23, dbo.InvAccum.OrgSentdate AS Expr24, dbo.InvAccum.INVOICE_DATE AS Expr27, dbo.InvAccum.ImageName, dbo.InvAccum.Print_Date, dbo.InvItem.RefNum, dbo.InvItem.Description, dbo.InvItem.ActualChgAmt, dbo.InvItem.NormChgAmt, dbo.InvItem.HCPCS, dbo.InvItem.DOSTo, dbo.InvItem.DOSFrom, dbo.InvItem.MedTon, dbo.InvItem.ItemCount, dbo.InvItem.PRODUCT_GROUP_CODE, dbo.InvItem.PharmacistLicNumber, dbo.InvHeader.Invoice AS Expr2, dbo.InvHeader.icode, dbo.InvHeader.ShortCut, dbo.InvHeader.SSN, dbo.InvHeader.FTClaimNumber, dbo.InvHeader.patient_id, dbo.InvAccum.RecDate, dbo.InvAccum.Routing, dbo.InvAccum.EDIFile, dbo.InvAccum.Carrier_Name, dbo.InvHeader.InjState, dbo.InvItem.Qty, dbo.InvItem.PO_NUMBER, dbo.InvItem.InvoiceFROM dbo.InvAccum INNER JOIN dbo.InvHeader ON dbo.InvAccum.Invoice = dbo.InvHeader.Invoice INNER JOIN dbo.InvItem ON dbo.InvHeader.Invoice = dbo.InvItem.InvoiceWHERE (dbo.InvAccum.RecDate > CONVERT(char(10), DATEADD(dd, - 1, GETDATE()), 101)) |
|
GETDATE problem