May 18, 2012 at 8:51 am
mtassin (5/18/2012)
Gazareth (5/18/2012)
dwain.c (5/18/2012)
I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy, I suppose I shall have to cease and desist.Merge statements are like that. Unless it's perfect they'll shoot you down at the slightest provocation 😀
Sometimes even then.... 🙂
MERGE is by far one of the most demanding and exact syntaxes I've worked with with SQL..... it's not really any more than any other statement, but so much is in one... that it's easy to get a little lost... and then get a cryptic MERGE error message back.
I had trouble with Merge when I first started using it. I'm used to it now, and it's easy. But it did take a dozen or so uses to get accustomed to the syntax enough that I could stop looking it up every time.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 18, 2012 at 9:01 am
GSquared (5/18/2012)
mtassin (5/18/2012)
Gazareth (5/18/2012)
dwain.c (5/18/2012)
I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy, I suppose I shall have to cease and desist.Merge statements are like that. Unless it's perfect they'll shoot you down at the slightest provocation 😀
Sometimes even then.... 🙂
MERGE is by far one of the most demanding and exact syntaxes I've worked with with SQL..... it's not really any more than any other statement, but so much is in one... that it's easy to get a little lost... and then get a cryptic MERGE error message back.
I had trouble with Merge when I first started using it. I'm used to it now, and it's easy. But it did take a dozen or so uses to get accustomed to the syntax enough that I could stop looking it up every time.
I do seem to make more mistakes with it than other constructs. I think it's probably just as it's quite new to me relative to the decade or so I've spent with most of the rest of the DML statements. It's quite common for me to be half way through writing a merge statement and have SQL Prompt stop prompting me. *It* knows I've made a mistake somewhere, *I* know I've made a mistake somewhere, but damned if I can see it before finishing the statement and trying to compile 😀
May 18, 2012 at 9:10 am
GSquared (5/18/2012)
mtassin (5/18/2012)
Gazareth (5/18/2012)
dwain.c (5/18/2012)
I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy, I suppose I shall have to cease and desist.Merge statements are like that. Unless it's perfect they'll shoot you down at the slightest provocation 😀
Sometimes even then.... 🙂
MERGE is by far one of the most demanding and exact syntaxes I've worked with with SQL..... it's not really any more than any other statement, but so much is in one... that it's easy to get a little lost... and then get a cryptic MERGE error message back.
I had trouble with Merge when I first started using it. I'm used to it now, and it's easy. But it did take a dozen or so uses to get accustomed to the syntax enough that I could stop looking it up every time.
Yeah, took me a while too, pretty comfortable with the syntax now.
They're still a pain to debug though :crazy:
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply