Recent content by Fenrir

Thank you Jon K!

I have a table with the columns and the rows both as parmeters for a query. I know it's probably brain freeze but I can't figure out how to do it using only one statement. Example - a b c d 1 5 3 2 6 2 2...

I have a situation in which the user enters a test score and it is filtered through a bunch of data to get a percentile rank. Now there are three sets of data the raw score, standard age score, and finally the percentage. I need the user to put in the raw score, the grade and the age level...

Thanks for the reply Doc_man! For the last two days I have been having the sys admin check things like that. I've had the users that have XP os move to the NT boxes and login to rule that out. What I've found is that it is operating system specific. User accounts that get the ODBC call...

I've recently upsized a clients backend to SQL. It went fairly well and I've work through all the problems except the one I'm about to explain to you. I have a situation in which the deletion of records causes an ODBC call failed error on XP and 2000 machines but the deletion works perfectly...