Viewing 15 posts - 796 through 810 (of 10,144 total)
Haha thanks Kevin - but I'll wait and see if it works for the OP before pulling a pint 😉
April 21, 2017 at 7:52 am
April 21, 2017 at 5:16 am
April 20, 2017 at 10:14 am
April 20, 2017 at 9:28 am
April 20, 2017 at 9:21 am
April 20, 2017 at 9:03 am
Something like this?SELECT
SO.ORDER_DATE,
SOL.SYS_DELIVERY_DATE, SOL.SYS_SHIPPING_DATE,
SO.ORDER_NUMBER, SOL.ORDER_LINE_NUMBER,
SOL.PART_CODE,
SLQ.ORDER_QUANTITY,
SLQ.UNIT_OF_MEASURE
FROM SALES_ORDERS SO
INNER JOIN SALES_ORDER_LINES SOL
ON SOL.ORDER_NUMBER = SO.ORDER_NUMBER
INNER...
April 20, 2017 at 7:36 am
Can you post the query for the view v_SaleSMS6OpportunityProp?
April 19, 2017 at 8:14 am
Firstly - can you prepare the sample data properly please? That means preparing INSERTs to populate a table, and making sure that the data provided adequately reproduces the problem domain.
April 12, 2017 at 8:54 am
Here's a somewhat simpler version:SELECT t.ID, t.StartDt, t.EndDt,
MinutesWorked = SUM(CASE WHEN ActualDayStart < ActualDayFinish THEN DATEDIFF(MINUTE,ActualDayStart,ActualDayFinish) ELSE 0 END)
FROM @t t
CROSS APPLY (
April 12, 2017 at 7:51 am
April 11, 2017 at 8:24 am
Viewing 15 posts - 796 through 810 (of 10,144 total)