Sorry i wrote it wrong it should be;
SELECT COUNT (*)
FROM #WorkingData
WHERE ledger_id2 IS NULL
AND ledger_id1 < 0
AND DATEDIFF ( mi , invoice_date1, invoice_date2) > 60
does this make a difference?
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |