Once had a very similar issue. Tho is was for a dbase 4 file. The issue was that after the upgrade with had to add admin as the...

staindromeo1 (6/27/2011)

---

Alright mate,

There is no other table where the value exists, If its Other or No , I don't want it to do anything. Your Else statement doesn't seem...

I was thinking more about the windows logs.

I was actually doing both. Work first then answers in free times (using breaks during...

Sean Lange (6/27/2011)

---

I do know what to do on each layer and trust me you both are wrong, no other data engine, or layer, linq, entity framework, Datasets loops or...

Go back to school, you're way behind on the very basics...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

As I said, you need to find the right value. I'd guess that 0 means NO, 1 means Yes AND 2 means other. But you need to find...

Have you checked the windows error logs? There should be something in there to explain this behavior.

GSquared (6/27/2011)

---

I'd have to see your code to really get what you're running into.

I've never had a problem with error messages, et al, ending up in the message anywhere, but...

Add optional parameter @debug BIT = 0

Then if @debug = 1 PRINT 'Whatever'

Yes the dev server. But it needs to be on the server where the query will run (which very likely is not the report server which in my case...

Have you refreshed the agent status in EM? It probably won't auto-update just based on a query in QA.

This is really basic. You need to use the same datatypes on both sides of the equation. I can't see your screen and I can't do your work...

What's the condition that defines how the datas goes into what column?