Then you have to have some form of marker(unique incrementing identity/datettime) on the row to indicate...

What's your objection to a calendar table ?

Why not use

Select top (3) * from yourtable order by column desc

??

Did you read this ? http://www.sqlservercentral.com/articles/T-SQL/63003/

It tells you all you need to know.

Are you having trouble with it ? If so what is unclear ?

Also as you are on 2008 , or at least this is a 2008 forum, use Table valued parameters.

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Get out of the habit of looping , use tally tables

This ...

insert myTable(Activity_Codes)

select 'GL'+ Right('000' + convert(varchar(3), number),3) from master..spt_values where type = 'P' and...

Hi

Try this article http://www.sqlservercentral.com/articles/T-SQL/63003/

If i understand you correctly you just need to simply "outer join"

Please also see this article (and following discussion thread) for other methods of paging.

http://www.sqlservercentral.com/articles/T-SQL/66030/

Can you show us what you have attempted so far ?

Did you read up on row_number() ?

1) Have you set the "Text Qualifier" in the Connection manager to " ?

2) Does the data look ok when opened with notepad ?

Yup , exactly that , be careful that you filter out an quotes within the data as you will get the same issue.

Obviously no program can reliably tell the different between an content comma and a field separating comma.

The csv needs to be exported correctly , either use fixed lengths or a...

I wont tell you the answer, but here are some clues.

Investigate the row_number() function.

Wrap the query in a CTE

Filter on 'row_number = 2'