Viewing 15 posts - 13,771 through 13,785 (of 15,381 total)
Ninja's_RGR'us (10/11/2011)
Sean Lange (10/11/2011)
Kiara (10/11/2011)
Fal (10/10/2011)
But wait! There is a logic bug in Craig's code: "SELECT AwakeStat FROM tblTargets WHERE fname = 'Sean'" might return NULL.
<inserts copy/paste argument from...
October 11, 2011 at 7:17 am
Kiara (10/11/2011)
Fal (10/10/2011)
But wait! There is a logic bug in Craig's code: "SELECT AwakeStat FROM tblTargets WHERE fname = 'Sean'" might return NULL.
<inserts copy/paste argument from multiple other threads...
October 11, 2011 at 7:01 am
You are welcome although I am not sure how much help I actually provided. Maybe just acted as a sounding board for you. At any rate, glad you at least...
October 10, 2011 at 3:19 pm
Maybe an insert trigger to kill the garbage before it gets in? Those non-viewable characters can be a real pain in the ... if you don't know they are there....
October 10, 2011 at 3:11 pm
Evil Kraig F (10/10/2011)
Sean Lange (10/10/2011)
Craig Farrell
Liverwurst always comes to worst....Yeah, I'm a bit loopy today. :hehe:
Today??? 😛
Hmmmmm.....
WHILE @TargetStatus = 'Conscious'
BEGIN
EXEC spr_BeatWithSalami @Target = 'Sean'
SET @TargetStatus = (SELECT AwakeStat...
October 10, 2011 at 3:00 pm
Well it does seem a little strange that the two different version of sql are handling these characters differently. So your old server is on SP2 and the newer one...
October 10, 2011 at 2:56 pm
Evil Kraig F (10/10/2011)
GSquared (10/10/2011)
Stefan Krzywicki (10/10/2011)
Roy Ernest (10/10/2011)
Grant started and I am scared of heckling him... He looks scary.
He's not scary! If worse comes to worse, buy him a...
October 10, 2011 at 2:29 pm
Are the versions of sql the same? Or is it the same db server with two versions of sql client? The version of windows shouldn't come into play at all...
October 10, 2011 at 2:28 pm
That is table view. Is the database version the same on both? The "garbage" character is still there just not visible in SSMS. You could add a replace to your...
October 10, 2011 at 2:11 pm
OK so what do you mean by control characters? What are you seeing? Are you viewing in table view, text view?
October 10, 2011 at 1:42 pm
What are you viewing the query results with?
October 10, 2011 at 1:20 pm
Well by definition you can't return anything if there are no records. 😉 You would have to force the query to always return a resultset.
Something like this:
select top 1 name...
October 10, 2011 at 12:36 pm
As said above the logic of your trigger is not going to work for multiple inserts. It needs to be flexible to handle this. If you want some help there...
October 10, 2011 at 10:38 am
Happy to help. Hope that worked for you.
October 10, 2011 at 8:35 am
Oh yeah, the reason you are getting those error is because you aliased your tables and still trying to refer to them by their original name.
October 10, 2011 at 8:11 am
Viewing 15 posts - 13,771 through 13,785 (of 15,381 total)