Hi there mate

You need and aggregator around your vcValue column I think here. Example MAX()

Imagine you had two rows with the same paramter name. SQL need to know how to...

sorry the they should have said then

to solve the problem i changed this.

SELECT d.DM_Domain_Name AS [Domain] ,

c.CT_Category_Desc AS Category ,

...

yer hopefully one day the query engine will cache caluculations done on current date and they we can put this inline in the sql 🙁 🙂

Cheers anyone for looking but i have now fixed this.

if you calculate the date in a variable prior to doing the select then it comes back fine.

If your trying to get the country from the datestamp this will be hard as many countrys resisde in the same zones.

Also if you are trying to get the Zone...

if you upgrade to new SQL 2012 you can use EOMONTH()

Hi Could you not just use a datetimeoffset and substring off the timezone.

Or am i missing your point entirely?