Fortunately the only timezone conversion required will be between GMT and BST.

There is also a Date field which obviously provides me with a reference to know when the conversion should...

I'm not sure if bumping posts is frowned upon here; if so then apologies, the topic flew off the front page pretty quick so I thought maybe it got missed.

Anybody...

Just got this working by doing the following:

--------------------------------------------------------------

declare @vname varchar(50),

@aname varchar(50),

@tname varchar(50),

@insagg varchar(200)

declare cur cursor for

select a.rep_view_id, a.par_agg_col_name, b.table_name

from dm.report_view as a, dm.rep_to_tab as c, dm.report_table as b

where...