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 |
|
velvettiger
Posting Yak Master
115 Posts |
 Posted - 2008-07-30 : 10:56:46
|
| Hi everyone,I am importing some transactions in a table and it quite a bit of information.On a monthly basis I can get sometimes more than 670,000 transactions per store. I am loading 5 stores worth of information each having the 670,000 transactions for 17 months and as time go on I will keep on adding information.If I want to display all of the information going into the tables, I find that I can only view like for example 900,000 rows, When in reality they are over 4 million rows. Of course when i read the messages it says 4 million rows have been affected but i can only view on the screen 900,000. If I export it to a text file I can view all of the rows in the table. How can I fix this problem so that that the 4 million rows be displayed once i do a select * from tablename ? |
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-30 : 11:00:44
|
| Are you storing all the datum in a single table ah..? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-30 : 11:03:36
|
| Have never noticed such an issue before. |
|
|
|
velvettiger
Posting Yak Master
115 Posts |
Posted - 2008-07-30 : 11:28:52
|
| Yup, I am storing everything in a single table |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-07-30 : 21:07:05
|
quote:
If I want to display all of the information going into the tables, I find that I can only view like for example 900,000 rows
Where are you displaying these records ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-30 : 21:15:29
|
| I think you can use SSIS package for it. Use Data viewer . |
|
|
|
|
|
|
|
|
Display all the items in a table