Viewing 15 posts - 1,726 through 1,740 (of 3,232 total)
It looks to me like the only reason you need some sort of cursor/loop is because your stored procedure is designed to work on one row at a time. ...
June 11, 2008 at 10:04 am
Glad to hear. Yea, we had 2 to tornadoes touchdown within about 45 mintues of here last night. That's Nebraska for you, flat land w/ no directional landmarks,...
June 5, 2008 at 2:36 pm
OK, that makes sense, you're capturing the queries manually through Visual Studios. In that case, you'll have to do as previously suggested and first past it into a text...
June 5, 2008 at 9:48 am
We're all still speculating as to what we think the problem is.
Marcus, how are you capturing the queries from Reporting Services? Can you give us an example...
June 5, 2008 at 8:44 am
Bingo. That should do it.
June 4, 2008 at 10:27 am
Where are you reading the query in from?
June 3, 2008 at 4:17 pm
It's hard to say without knowing a bit more. You'll need to post your code as well as the table DDL, sample data (in the form of inserts) and...
June 3, 2008 at 3:58 pm
Well, there have been some good suggetions for you here. Care to give a little feedback on where you're at with this one?
May 30, 2008 at 3:08 pm
I'm in Omaha.
And I'm just as guilty as anyone else with jumping in and posting an answer when there are some valid outstanding questions that the OP has not answered....
May 29, 2008 at 6:14 pm
NE huh. Welcome to my stomping grounds. If after you drive in and out of the state, you have any questions about oh, say....corn. Let me know!!...
May 28, 2008 at 8:51 am
What exactly are you trying to do? Why do you want the SP to get the results this way?
May 27, 2008 at 1:57 pm
With your SELECT INTO FROM statement, your stored procedure will get recompiled every time it runs. When you ran them, did you run the entire contents of the SP,...
May 27, 2008 at 11:06 am
Have you tried running these queries outside of a stored procedure and seeing what results they produce?
May 27, 2008 at 10:54 am
Thats kind of the direction that I was taking here. This is outside of SQL and has something to do with the application, codepage, etc (which is also outside...
May 27, 2008 at 9:12 am
Viewing 15 posts - 1,726 through 1,740 (of 3,232 total)