Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-26 : 11:34:53
|
| Jay writes "I'm querying and AS400 using OPENQUERY but am finding that the number of rows return is not equal to the 'real' rowcount of the table in question.I did notice a thread on this subject but it had no resolution so HHEELPPP!I can see no pattern to the number of rows return e.g. on a table with 18 rows, I get 1. On a table with 6229 rows I get 6203.Any help would be very much appreciated.Jay" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-26 : 12:42:12
|
| Could it have to do with permissions?Tara |
 |
|
|
|
|
|
Using OpenQuery to query a linked AS400