title: Table Column as Array in T-SQL
body: <p>Instead of traversing a table using a cursor, I'd like to populate an ARRAY with the table column data and then rather traverse the T-SQL array for my calculations or whatever, using something like "while not end-of-file do something".  I feel this will minimize disk usage and be much more efficient.</p>