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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Select into FOR Large row number

Author  Topic 

snow12
Yak Posting Veteran

74 Posts

Posted - 2009-10-14 : 18:45:27
I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table?

select id, code into Tem_table from RMPROP where code = '11'

Your help is highly appreciated.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-10-14 : 18:47:24
remove the where clause ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-10-14 : 18:59:41
Is this like a guessing game?

"I have 3 girlfriends...which one should I keep happy?"



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-10-14 : 19:07:12
quote:
Originally posted by X002548
"I have 3 girlfriends...which one should I keep happy?"



All ?
select name from girlfriends


randomly ?
select top 1 name from girlfriends order by newid()



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-15 : 02:32:56
quote:
Originally posted by snow12

I have row number with more than 400 rows. I use select into statement. It only allow 175 rows to get copied into Tem_Table. How to get all rows copied when create new table?

select id, code into Tem_table from RMPROP where code = '11'

Your help is highly appreciated.


How many rows does this return?

select id, code into Tem_table from RMPROP where code = '11'

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -