Viewing 15 posts - 226 through 240 (of 10,144 total)
Force the join between B and C to take place first, and you change the result:
SELECT *
FROM TABLE_A
LEFT JOIN TABLE_B
INNER JOIN TABLE_C
ON TABLE_B.ID =...
November 7, 2018 at 3:36 am
November 7, 2018 at 1:54 am
November 6, 2018 at 2:52 am
November 5, 2018 at 8:12 am
Something like this:
SELECT
[RowIsValid] = CASE
WHEN AFG = 'Yes' OR [Type] = 'N/A' THEN 1
WHEN AGF = 'No' OR [Type] = 'Phys' THEN 2
END,
October 31, 2018 at 7:00 am
October 30, 2018 at 10:49 am
October 30, 2018 at 3:55 am
October 26, 2018 at 7:13 am
A simple test harness shows that the method works:
;WITH
October 26, 2018 at 7:10 am
Unusually complicated for a simple update:
UPDATE dbo.clean_hotelbookings
October 26, 2018 at 6:59 am
I hate having a SSIS package fail and fail again when being run from...
October 26, 2018 at 6:48 am
October 26, 2018 at 2:17 am
Viewing 15 posts - 226 through 240 (of 10,144 total)