Comments
Sort by recent activity
Ahh. I was relying on the formatting to do that for me.
One ponders who would create a transaction called, "THROW", but then... / comments
Ahh. I was relying on the formatting to do that for me.
One ponders who would create a transaction called, "THROW", but then...
David,
I can confirm this is fixed in the latest release.
Best,
John / comments
David,
I can confirm this is fixed in the latest release.
Best,
John
Very helpful guys - thank you!
Best,
John / comments
Very helpful guys - thank you!
Best,
John
Aaron,
I can confirm that the new build fixes the issue.
Best,
John / comments
Aaron,
I can confirm that the new build fixes the issue.
Best,
John
I can confirm that the new build does not place brackets around $action.
Thanks,
John / comments
I can confirm that the new build does not place brackets around $action.
Thanks,
John
I'm sure it's like playing whack-a-mole.
Thanks for your efforts. / comments
I'm sure it's like playing whack-a-mole.
Thanks for your efforts.
That worked, thank you!
Best,
John / comments
That worked, thank you!
Best,
John
Hello,
I can confirm that the fix works in the latest 6.5.0.255 beta for the merge stanza issue.
Best,
John / comments
Hello,
I can confirm that the fix works in the latest 6.5.0.255 beta for the merge stanza issue.
Best,
John
Running 6.5.0.254, SQL 2012, SP2/CU4
First section is the code as/is.
Second section shows post-formatting for "Qualify Object Names".
The when not matched by target insert chooses the wrong qualifier, if one needs to be chosen at all. MERGE Employees AS T
USING StageEmployees AS S
ON (T.person_id = S.person_id)
WHEN MATCHED THEN
UPDATE SET
T.last_name = S.last_name,
T.first_name = S.first_name,
T.middle_name = S.middle_name,
T.aka = S.aka,
T.empno = S.empno,
T.store = S.store,
T.hr_is_active = S.hr_is_active,
T.job_code = S.job_code
WHEN NOT MATCHED BY SOURCE THEN
DELETE
WHEN NOT MATCHED BY TARGET THEN
INSERT (last_name,
first_name,
middle_name,
aka,
person_id,
empno,
store,
hr_is_active,
job_code
)
VALUES (S.last_name,
S.first_name,
S.middle_name,
S.aka,
S.person_id,
S.empno,
S.store,
S.hr_is_active,
S.job_code
);
MERGE Employees AS T
USING StageEmployees AS S
ON (T.person_id = S.person_id)
WHEN MATCHED THEN
UPDATE SET
T.last_name = S.last_name,
T.first_name = S.first_name,
T.middle_name = S.middle_name,
T.aka = S.aka,
T.empno = S.empno,
T.store = S.store,
T.hr_is_active = S.hr_is_active,
T.job_code = S.job_code
WHEN NOT MATCHED BY SOURCE THEN
DELETE
WHEN NOT MATCHED BY TARGET THEN
INSERT (S.last_name,
S.first_name,
S.middle_name,
S.aka,
S.person_id,
S.empno,
S.store,
S.hr_is_active,
S.job_code
)
VALUES (S.last_name,
S.first_name,
S.middle_name,
S.aka,
S.person_id,
S.empno,
S.store,
S.hr_is_active,
S.job_code
);
Thanks,
John / comments
Running 6.5.0.254, SQL 2012, SP2/CU4
First section is the code as/is.
Second section shows post-formatting for "Qualify Object Names".
The when not matched by target insert chooses the wrong qualif...
Hello, I'm running the version, 6.5.0.234 - 24th February.
I'm on SQL 2012, latest SP/CU.
Doing the, "Qualify object names" produced unexpected results in the joins after the, "HAVING" clause... basically it should join the preCheckout to the tmp table, not tmp to tmp.
I'm positive there is a more graceful way to achieve the results, but nevertheless.
BEFORE:
SELECT COUNT(preCheckout.EmpPersonID) countemppersonid
FROM preCheckout
WHERE preCheckout.CheckoutDate IN (SELECT CheckoutDate
FROM preCheckout AS tmp
GROUP BY CheckoutDate,
EmpPersonID,
StoreNum,
Period,
EmpPosition
HAVING COUNT(*) > 1
AND EmpPersonID = preCheckout.EmpPersonID
AND StoreNum = preCheckout.StoreNum
AND Period = preCheckout.Period
AND EmpPosition = preCheckout.EmpPosition)
AND preCheckout.StoreNum = @StoreNum
AND preCheckout.CheckoutDate = @Date
AND preCheckout.Period = @Period
AFTER:
SELECT COUNT(preCheckout.EmpPersonID) countemppersonid
FROM preCheckout
WHERE preCheckout.CheckoutDate IN (SELECT tmp.CheckoutDate
FROM preCheckout AS tmp
GROUP BY tmp.CheckoutDate,
tmp.EmpPersonID,
tmp.StoreNum,
tmp.Period,
tmp.EmpPosition
HAVING COUNT(*) > 1
AND tmp.EmpPersonID = tmp.EmpPersonID
AND tmp.StoreNum = tmp.StoreNum
AND tmp.Period = tmp.Period
AND tmp.EmpPosition = tmp.EmpPosition)
AND preCheckout.StoreNum = @StoreNum
AND preCheckout.CheckoutDate = @Date
AND preCheckout.Period = @Period
Best,
John / comments
Hello, I'm running the version, 6.5.0.234 - 24th February.
I'm on SQL 2012, latest SP/CU.
Doing the, "Qualify object names" produced unexpected results in the joins after the, "HAVING" clause... ba...