Viewing 15 posts - 2,881 through 2,895 (of 14,953 total)
Try moving the Where clause inside the CTE.
What it looks like to me is that you're getting a Join Math issue, caused by the fact that the CTE is actually...
- 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
November 10, 2011 at 8:28 am
Yep, you'll have to use dynamic SQL for this. No way around it.
- 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
November 10, 2011 at 7:06 am
The XQuery documentation is horrific. Struggling through it is almost a career all by itself. The way I've had to learn it is by trying things, changing one...
- 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
November 10, 2011 at 7:02 am
SQLRNNR (11/9/2011)
GSquared (11/9/2011)
GilaMonster (11/8/2011)
How can BCNF be sensibly discussed if the earlier normal forms aren't known?
Same way you can teach Algebra without learning Arithmetic first. You just ... uh...
- 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
November 10, 2011 at 6:25 am
I wouldn't upload the database if I were you.
The usual thing is to post create scripts for the tables in the query, and a few rows worth of insert statements...
- 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
November 10, 2011 at 6:08 am
Actually, the Where clause probably needs to be IN not =, and a list of the values to update.
- 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
November 9, 2011 at 8:16 am
Stefan Krzywicki (11/9/2011)
Brandie Tarvin (11/9/2011)
GSquared (11/9/2011)
GilaMonster (11/9/2011)
Ninja's_RGR'us (11/9/2011)
Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx
Haven't you forgotten...
- 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
November 9, 2011 at 8:15 am
Actually, those aren't even equivalent queries.
Update MyTable Set MyField=@parm1
Where (ReferenceID is null or ReferenceId=@parm2);
OR
Update MyTable Set MyField=@parm1
Where ReferenceID = IsNull(@parm2, ReferenceID);
The first one will update all rows where ReferenceID is...
- 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
November 9, 2011 at 8:11 am
GilaMonster (11/9/2011)
Ninja's_RGR'us (11/9/2011)
Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx
Haven't you forgotten the old saying - 'Those...
- 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
November 9, 2011 at 8:03 am
Best way to find out if it will perform okay or not, and is secure or not, etc., would be to open it up for use by anyone who wants...
- 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
November 9, 2011 at 8:01 am
Turn it into an Update instead of a Select.
- 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
November 9, 2011 at 7:55 am
IceDread (11/9/2011)
Eric M Russell (11/9/2011)
IceDread (11/8/2011)
- 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
November 9, 2011 at 7:54 am
Well, it's kind of like "penny for your thoughts", but what with inflation and all ....
- 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
November 9, 2011 at 7:17 am
Koen Verbeeck (11/9/2011)
L' Eomot Inversé (11/9/2011)
Koen Verbeeck (11/8/2011)
L' Eomot Inversé (11/8/2011)
- 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
November 9, 2011 at 7:09 am
Is the file local to the server, or on a separate machine?
- 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
November 9, 2011 at 6:45 am
Viewing 15 posts - 2,881 through 2,895 (of 14,953 total)