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.
Sounds like you want to make use of "IS NOT NULL".
Something like this should work:
EDIT: just noticed your using msdasql, not sure that syntax is going to work for you.
WHERE yourColumnName IS NOT NULL
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