If i'm selecting * from a table and i get an error like so:
(9 row(s) affected)
Msg 7342, Level 16, State 1, Line 5
An unexpected NULL value was returned for column "[MSDASQL].lastupdatedate" from OLE DB provider "MSDASQL" for linked server "AP_TRAINER". This column cannot be NULL.
is there a way to ignore those rows and still pull the data i want? This would be very helpful if so... any help would be greatly appreciated. Thank you.
12-13-2012, 09:32 PM
Sounds like you want to make use of "IS NOT NULL".
Something like this should work:
WHERE yourColumnName IS NOT NULL
EDIT: just noticed your using msdasql, not sure that syntax is going to work for you.
12-14-2012, 02:16 AM
thanks for chiming in though.. i'll see what i can figure out by morning time.. but if you happen to have any more ideas.. please share a good work around this