Viewing 15 posts - 2,161 through 2,175 (of 18,926 total)
I don't understand why you'd ever need such a business requirement.
What are you trying to accomplish exactly (big(ger) picture)?
October 7, 2011 at 6:55 am
What if you try to make 2 new procs (one for each part of the if). And see if that fixes it.
I don't know your front end and I...
October 7, 2011 at 5:56 am
Jnrstevej (10/7/2011)
The sp can run within ssms on my system would you like a copy of the DB?Do you mean the dataset within SSRS??
No & yes.
October 7, 2011 at 2:07 am
I've been watching. I've learned all I know from Grant and I haven't read more than 10% of his stuff (yet). So if he says there's nothing to...
October 6, 2011 at 11:48 am
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting older as well....
October 6, 2011 at 11:44 am
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting older as well. People I...
October 6, 2011 at 9:42 am
Well it compiles on my system but obviously doesn't run without the tables.
Can you run the sp alone in ssms?
If yes, you can try dumping the dataset and redoing it.
October 6, 2011 at 9:30 am
Might be simpler for you to post your query. It sounds like a simple syntax error.
Can you run that query in ssms all by itself?
October 6, 2011 at 8:58 am
How about creating a proc and use execute as?
October 6, 2011 at 8:06 am
@ Ninja originally i have tried to create a temp table in a SP. However, it doesn't matter what i try SSRS does not read temp tables i continuously get...
October 6, 2011 at 7:53 am
Ninja's_RGR'us (10/6/2011)
http://sqlfool.com/2011/06/index-defrag-script-v4-1
That'll find the problem indexes AND fix them. What else can you possibly need?
October 6, 2011 at 7:10 am
It's a double word play. RG => Remi Gregoire
Rus for like toys r us.
Sushila had originally come up with this much better meaning => Resident Genius / Ubiquitous...
October 6, 2011 at 6:38 am
Lowell (10/6/2011)
Ninja's_RGR'us (10/6/2011)
you're telling the server to do this, which is impossible :update set colum = (SELECT col1, col2, ... FROM )
sigh...Ninja'd again...well deserved nickname, for sure.
Well you guys...
October 6, 2011 at 6:25 am
you're telling the server to do this, which is impossible :
update set colum = (SELECT col1, col2, ... FROM )
October 6, 2011 at 6:23 am
Viewing 15 posts - 2,161 through 2,175 (of 18,926 total)