Here's something. Assuming the table [tablename] was made like this:
--USE [cpqaAnswers]
--GO
--CREATE SCHEMA [cpqa]
CREATE TABLE [cpqa].[tablename](
[row][nvarchar](76)
)
Do this:
CREATE TABLE [cpqaAnswers].[cpqa].[tablenameIdx](
[theRowNumber][int]IDENTITY(1,1),
[row][nvarchar](76)
)
Then, do this:
INSERT INTO [cpqaAnswers].[cpqa].[tablenameIdx]
SELECT * FROM [cpqaAnswers].[cpqa].[tablename]
Now there's an index prefixed to the previous data table and, using the assignment style mentioned, each line of data is accessible through it.