In all the work I've done attempting to "rank" data, I've found MAX not to be useful. I think its really only good for math, or single value...

Interesting. Can this work for actual data removal at the table level (instead of temp table)?

No, the MAX condition always seems to get satisfied. (also their are many other columns in my project). I tried this first of course, but it never seems to work.

Thks, I'll try fooling with spacing nested within IF statments, to determine which data rows need the padding.

STUFF delete's data (if thats what you were advising). Thks for the craptastic response....

Interesting. It works perfectly when placing it into a pre-existing Excel document:

osql /Usa /P /dDATABASE /S /Q "Insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\test.xls;HDR=YES', 'SELECT * FROM [sheet1$]')Select * from SUPPLYLIST where...

Interesting, I never knew you could append a ranking next to the select command. Works very well. My header/footers are not column names or fields, but extraneous(dates, batch numbers etc..)....

Parles-tu Francais?

I have a select statement, that generates a flat file, and sends it to a FTP site. These files need batch records appended to them (header/footer)...

Excellent. Thanks a bunch. I'm having to great a stored proc for a large VIEW, instead of having it inside the TSQL JOBs window which is foolishly truncated to only...

I'm running these reports on a timed basis, hence using T-SQL scripts in JOBS. DTS stinks, and is foolishly limited in what it can do. There are no format commands...

I used INSERT INTO a new TABLE (instead of VIEW) using the original VIEWS data. I placed this above the Helen's brillant commands. Works like a charm. Thanks to all....

Yes, Helen's query outputs all tables (even other VIEWS, not as complex) just not the VIEW I'm needing. It gives me COLLATION/SUBSTRING error. Very weird. I'm going to try...

This worked like a charm, thanks. The only other detail is that I'm using VIEWS for my output. It didn't seem to like it. It works for all the other...