Viewing 15 posts - 6,316 through 6,330 (of 18,926 total)
Lowell (5/9/2011)
mikeincape (5/9/2011)
Ahhh Ha!Ok.... Runs fine on my server. Must be from using the express version on my local pc...
[fist pump] YES!!!!
BOTH hands on the keyboard plz! :smooooth:
May 9, 2011 at 11:27 am
mikeincape (5/9/2011)
Ninja's_RGR'us (5/9/2011)
Lowell (5/9/2011)
Ninja's_RGR'us (5/9/2011)
It's definitely possible, but if he could run my create db code, then I don't see why it would fail there (never seen that before).
The only...
May 9, 2011 at 11:17 am
We're missing something really simple. Like running on wrong server, wrong DB, stupid syntaxe issue. Maybe a trigger somewhere?!?!?
Are you running something else in that batch?
I'm going to...
May 9, 2011 at 11:15 am
Lowell (5/9/2011)
Ninja's_RGR'us (5/9/2011)
It's definitely possible, but if he could run my create db code, then I don't see why it would fail there (never seen that before).
The only thing I...
May 9, 2011 at 11:10 am
mikeincape (5/9/2011)
Are you using any 3rd party application that refactors sql?
Using SQL management Studio to execute the queries you are sening me... No 3rd party apps anywhere.
Also, we've done it...
May 9, 2011 at 11:09 am
Lowell (5/9/2011)
mikeincape (5/9/2011)
Yes... This gives me the dataset I need. Thanks!... Still getting that weird error though... Any Ideas?
Ninja's is going to kick me for repeating what he already proved...
May 9, 2011 at 11:07 am
alan.williams (5/9/2011)
Why not just do a Union of the two queries
Delete that line
WHERE RW = 1
May 9, 2011 at 11:05 am
Union <all> add rows, in this case he wants columns.
May 9, 2011 at 11:04 am
Are you using any 3rd party application that refactors sql?
BTW, the 1st left join will return ALL ROWS instead of 1, I'm not sure this is what you want. ...
May 9, 2011 at 11:03 am
mikeincape (5/9/2011)
Your test query executed successfully.
Ok then post the full code you are running, maybe we're missing something obvious... or you're running it on the wrong server :w00t:.
May 9, 2011 at 10:47 am
mikeincape (5/9/2011)
May 9, 2011 at 10:44 am
If the query runs then youre problem is elsewhere!!!
Just for the fun of it, run my script and see if that works. That'll confirm if the server's able to...
May 9, 2011 at 10:43 am
Then it's most likely a permissions issue.
I've seen session problems in ASP.net but I don't see how those could apply here.
May 9, 2011 at 10:41 am
I have to have to use it myself... but that's the way it works right now!
May 9, 2011 at 10:39 am
mikeincape (5/9/2011)
I just looked and I am in 90 compatibility mode.
Then with the comma added, what error are you getting (if any)?
May 9, 2011 at 10:38 am
Viewing 15 posts - 6,316 through 6,330 (of 18,926 total)