Viewing 15 posts - 31 through 45 (of 109 total)
Hi Kevin,
Thanks for getting in touch.
I'm getting the following error...
Incorrect syntax near ')'.
October 7, 2021 at 12:37 pm
Thanks for responding...
October 6, 2021 at 9:34 pm
Thank you
October 6, 2021 at 11:58 am
Hi Jonathon,
tbl_probate_case does not have column named case_submitted_date.
I very clever person on another forum has already advised me that the problem was the missing column. The thrust behind this question...
October 1, 2021 at 1:38 pm
Hi Brian,
I hope the person that originally told me what the problem doesn't read this post, as he was extremely helpful and I don't want to undermine him. But I...
September 30, 2021 at 10:52 pm
I should mention the following is the code it is RAW PL / SQL format that works in production
SELECT m.ce_case_data_id, -- AS case_data_id
...
September 30, 2021 at 8:49 pm
The answer to this question is the innerjoin does not have common value across tables.
Please disregard
September 30, 2021 at 2:45 pm
I just realised I didn't include the missing table tbl_probate_case
CREATE TABLE tbl_probate_case (
case_data_id nvarchar(50),
...
September 30, 2021 at 1:41 pm
Actually, please DONT forget this question. I have noticed that I'm still not getting any results even after there is a match with the Inner Joins...
You're help much appreciated.
September 30, 2021 at 1:26 pm
Please forget this question. I figured it out.. There aren't any matches in the inner-joins
September 30, 2021 at 1:22 pm
OK,
I'm not sure if I should start a new question or continue with this question. However, I have got the original query to work, see below, but I'm not getting...
September 30, 2021 at 12:08 pm
ok, can you help with the following conversion of Oracle PL SQL to T-SQL
It was mentioned that T-SQL doesn't use NVL, therefore I should change
SET trg.case_submitted_date = NVL(trg.ce_app_sub_date, src.case_submitted_date)
to
CASE WHEN...
September 28, 2021 at 10:11 pm
I get what you're saying Phil.
Anyway, just for my piece of mind, Michael are you saying that with the error occur with the following:
p.ce_app_type ,
p.ce_app_sub_date ,
p.ce_reg_location ,
p.ce_will_exists ,
p.ce_iht_gross_value ,
p.ce_iht_net_value ,
p.ce_deceased_dod...
September 28, 2021 at 9:47 pm
Hi Phil,
I guess I asked a silly question, as I haven't heard from you....
September 28, 2021 at 3:44 pm
Viewing 15 posts - 31 through 45 (of 109 total)