Viewing 15 posts - 2,356 through 2,370 (of 7,636 total)
jcrawf02 (5/15/2009)
RBarryYoung (5/14/2009)
Paul White (5/14/2009)
Bob Hovious (5/14/2009)
May 15, 2009 at 12:11 pm
sperry (5/15/2009)[hrIs the cross join not responsible for creating a larger the necessary data set?
No. Although syntactically it is a CROSS JOIN, logically it is not because the WHERE...
May 15, 2009 at 12:06 pm
gyessql (5/15/2009)
You could also consider the option of dynamic querying
I am a big proponent of dynamic SQL, but I would not recommend it, because it not necessary for these cases...
May 15, 2009 at 12:00 pm
chandrika5 (5/15/2009)
The STDEV report has:1.STDEV per question and/or overall quiz.
2.Top 25% overall grade: performance % per each question
3. Bottom 20% overall grade: performance % per each question.
...
Stuck with #1.
You need...
May 15, 2009 at 11:54 am
Hmm, also, this query is not valid:
sperry (5/15/2009)
AVP.ID, --<<< No AVP alias?
PER.PersonID,
1,
1
FROM...
May 15, 2009 at 11:41 am
Hmmm, the multiple correlated subqueries of PERSON_SUBSET to itself are definitely a problem, and it does not appear that they are necessary.
May 15, 2009 at 11:26 am
Michael Valentine Jones (5/15/2009)
Why not just create a view in each database with the application ID hard coded in that view:
Create view vAppID as select AppID = 12345
This is actually...
May 15, 2009 at 11:24 am
The CROSS JOIN isn't your problem, it's just an INNER JOIN that has had it's ON conditions moved down to the WHERE clause. It'll act the same.
Your real problem...
May 15, 2009 at 11:00 am
A transport-level error is a network error.
May 15, 2009 at 10:46 am
praveenvelumula (5/15/2009)
I have gone through the Topic .."elimnating Cursors using While loop ".. that's great ..
Can you expand the Explanation please..
I have one store procedure...
May 15, 2009 at 10:44 am
I use xp_CmdShell a lot and I do the same thing as Florian. I never have been able to figure out these DOS return values to xp_CmdShell, they have...
May 15, 2009 at 10:43 am
lallen (5/15/2009)
The file is not on the same box as the server. But it is on a server that is part of our internal network.
In that case, could you...
May 15, 2009 at 10:35 am
Though you'd probably be better off getting rid of the cursor altogether.
May 15, 2009 at 10:14 am
To paraphrase Jack: There actually aren't any output only parameters in SQL procedures. They are all either input-only or input/output. You use the OUTPUT keyword in both...
May 15, 2009 at 10:08 am
Viewing 15 posts - 2,356 through 2,370 (of 7,636 total)