most useful thing to do is not to use * in views, but ignoring that ...

exec sp_refreshview <view>

will refresh a...

I like that one Jonathan

way better than mine

something like:

select A.serverid, A.jobname, max(A.procdate)

froma_tst A

join(

--get distinct job/processing days

select distinct jobname, convert(char(10), procdate, 112) procdate2

from a_tst

) B

onB.jobname = A.jobname

andB.procdate2 = convert(char(10), A.procdate,...

I think you'd need to use dynamic sql - you can pass the table & field names in as a varchar or sysname datatype and use sp_executesql (see BOL) in...

Right click in the query pane and select "Results in Text"

You'll probably also need to go into Tools->Options->Results tab

and set the Maximum characters per column to 8000 so it doesn't

truncate...

Apologies - I just read the "Can this be done without a cursor?"

topic a couple of topics ago and it seems to answer my question!