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...
November 10, 2011 at 8:28 am
Yep, you'll have to use dynamic SQL for this. No way around it.
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...
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...
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...
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.
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...
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...
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...
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...
November 9, 2011 at 8:01 am
Turn it into an Update instead of a Select.
November 9, 2011 at 7:55 am
IceDread (11/9/2011)
Eric M Russell (11/9/2011)
IceDread (11/8/2011)
November 9, 2011 at 7:54 am
Well, it's kind of like "penny for your thoughts", but what with inflation and all ....
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)
November 9, 2011 at 7:09 am
Is the file local to the server, or on a separate machine?
November 9, 2011 at 6:45 am
Viewing 15 posts - 2,881 through 2,895 (of 14,953 total)