use the self join as shown to create a view of the imported table which has each row as a separate column.

This self join view will look like this (3...

1) select columnlist into #temp from sampletable where 1=2

(temp tables are kept unique to the connection by the server)

2) Look up SET ROWCOUNT and/or usage of TOP w/ORDER BY in...

Do it another way using case statements.

Join your tables to select statements which retrieve the other info you want to use for comparison/manipulation.  Then build case statement to translate the...

You could always do it the old fashioned way: kluge

Like, BCP the thing as each row being separate row into a work table with an identity column to sequentially number...

Not much help but, off the top of my head...

You probably don't need to get rid of the column, just null the values.  The image datatype is a pointer to...