I was kind of hoping that there is a t-sql way of exporting data. Your can bulk insert wth t-sql, so why can't you bulk export.

Hi Lowell,

I must have copied it incorrectly, but it does work. I recopied and pasted the code and modified it to match my column names and it seems to...

"Mark says that if there is match between the values present in the columns, then he asks us to look at one priority table which will tel us which column...

Hi SSC-Enthusiastic,

it sort of works. This is what I get:

A B ...

If you look at the column priorties, Column E has a higher priority than Column A. There when both Columns E and A are = 1 then I would...

Thanks Lowell. But I wanted to include the priority settings as well, but can't figure out how to incorporate it.

Hi, here is a sample and expected result

A B ...

What I need is a single computed field to tell me which of the 5 count columns has the highest value for that row

When using a cursor, does it pull out the entire row, or can I tell it what fields to pull out from each row to populate my cursor variables?

I have...

Thanks a lot for your help