October 22, 2009 at 1:40 am
Skeeve
Are you using any date columns in the join or the where clause?
It would be helpful for everyone if you could post the table definitions , data to be inserted and the actual query.
Check this link http://www.sqlservercentral.com/articles/Best+Practices/61537/ on how to post sample data if you are doing it.
"Keep Trying"
October 22, 2009 at 7:37 am
Hey,
Excellent point about providing the table definition. Also, the link you suggested I look at is also helpful. I'm not a programming newbie, however, I am a forum-posting newbie because I rarely do it myself. Thanks for that advice.
There are two kinds of field associated with the query: 1) the IDs used in the joins are all int and 2) a bit (not null) field that I test for '=1' in the where clause.
That's it, really. The problem is I can't provide a test structure and test data because I have been completely unable to recreate the problem. It seems to exists only in this database on any MSDE 2000 engine. I have resolved to upgrading to 2008 because it's not my app and I can't do anything to alter the program anyway. I was just hoping to tell the vendor what to do. But the train has left the station on this, so the problem is not totally academic. 😉
Thanks so much.
October 23, 2009 at 12:59 am
All the best for upgrading to 2008 🙂
"Keep Trying"
October 23, 2009 at 7:50 am
Thanks ChiragNS!
Be well.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply