Viewing 15 posts - 1,456 through 1,470 (of 18,926 total)
Jeff Moden (11/10/2011)
I don't know if anyone else noticed but Gail isn't just the leading point holder anymore... she's also the leading poster![font="Arial Black"]Congrats Gail!!! [/font]
Actually I caught...
November 10, 2011 at 4:53 am
Dev @ +91 973 913 6683 (11/10/2011)
It's basically doing a cross join. Maybe the author didn't know about that option.
I haven't seen any instance when people use 1=1 by mistake....
November 10, 2011 at 4:48 am
As Gail said.
Both queries will give the correct results.
However, for readability I'll preffer cross join or cross apply in this situation. It makes it super obvious of what's going...
November 9, 2011 at 11:22 am
Well you could do it like this if you wanted to =>
FROM SchoolProgram srp
INNER JOIN @Programs pr ON srp.ProgramID = 7
November 9, 2011 at 11:15 am
Roy Ernest (11/9/2011)
L' Eomot Inversé (11/9/2011)
GilaMonster (11/9/2011)
Roy Ernest (11/9/2011)
November 9, 2011 at 11:04 am
It's basically doing a cross join. Maybe the author didn't know about that option.
Outer apply might be my choice here depending on the real requirements.
November 9, 2011 at 10:57 am
Sapen (11/9/2011)
I will create the missing index and see if there is any change in the wait types.Thanks Much Gail.
Can't be. You will return the exact same amount...
November 9, 2011 at 10:07 am
GilaMonster (11/9/2011)
SQLRNNR (11/9/2011)
GilaMonster (11/9/2011)
Roy Ernest (11/9/2011)
November 9, 2011 at 9:50 am
You need quadruple quotes when you're in double dynamic sql.
November 9, 2011 at 9:44 am
Dev @ +91 973 913 6683 (11/9/2011)
November 9, 2011 at 8:39 am
Dev @ +91 973 913 6683 (11/9/2011)
I have limited knowledge on them so wanted to know more. Nothing else.
I'm not saying you did anything wrong. I just don't know...
November 9, 2011 at 8:31 am
Dev @ +91 973 913 6683 (11/9/2011)
I noticed you (Gail) in the...
November 9, 2011 at 8:23 am
-Syd- (11/9/2011)
The report was working correct!! Just went wrong a few minutes ago!
It's an intermittant error.
You can be 100% certain it will happen again. It's just a matter of...
November 9, 2011 at 8:22 am
-Syd- (11/9/2011)
Im trying to make an INSERT on a temp table.
Which usually means that you read data from another table.
Changes nothing from your problem.
Any reasons why you think bad data...
November 9, 2011 at 8:02 am
Viewing 15 posts - 1,456 through 1,470 (of 18,926 total)