SQL Select - SQL Server Forums

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

SQL Select

Author

Topic

chriztoph
Posting Yak Master

184 Posts

Posted - 2010-10-20 : 00:20:48

Hi!

select * from OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
    'Excel 12.0;HDR={1};Database=C:\Users\crlibrero\Desktop\BSP TEMPLATE.xls;', 
    'SELECT * From [Sheet1$]')

i have this query, it runs perfectly.

what i want to do is to select start from 3rd row to n row..
how can i do that?

Thanks in advance..

Sachin.Nand

2937 Posts

Posted - 2010-10-20 : 01:57:21

[code]

select * from
(
select *,ROW_NUMBER()over(order by (select 1))rid from
(
select * from OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;HDR={1};Database=C:\Users\crlibrero\Desktop\BSP TEMPLATE.xls;',
'SELECT * From [Sheet1$]')
)T
)T1 where rid between 3 and 'your n row'

[/code]

PBUH

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-10-20 : 02:41:04

quote:

Originally posted by Sachin.Nand



	select * from
		(
		select *,ROW_NUMBER()over(order by (select 1))rid from
		(
			select * from OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
				'Excel 12.0;HDR={1};Database=C:\Users\crlibrero\Desktop\BSP TEMPLATE.xls;', 
				'SELECT * From [Sheet1$]')
		)T
	)T1 where rid between 3 and 'your n row'

PBUH

Can be rewritten like below -


select from
(
	select *,ROW_NUMBER()over(order by (select 1))rid from OPENROWSET('Microsoft.ACE.OLEDB.12.0', 
		'Excel 12.0;HDR={1};Database=C:\Users\crlibrero\Desktop\BSP TEMPLATE.xls;', 
		'SELECT * From [Sheet1$]')
)T where rid between 3 and 'your n row'

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

Sachin.Nand

2937 Posts

Posted - 2010-10-20 : 02:53:00

quote:
Can be rewritten like below -

select * from
(
select *,ROW_NUMBER()over(order by (select 1))rid from OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;HDR={1};Database=C:\Users\crlibrero\Desktop\BSP TEMPLATE.xls;',
'SELECT * From [Sheet1$]')
)T where rid between 3 and 'your n row'

Yup