Hi Tomm

thanks for the response, is there a way to simplify your calculation in order to give me the sum in one line in the report.

eg. adding up row A...

Thanks for the response, unfortunately AVG(Texbox1/(FaceTime-Texbox2)) doesn't work cause Textbox1 & Textbox2 are already summed,

the records e.g BA1202 are grouping and they already have calculated values.

thank you so much guys it really does help with what I need to achieve.

Here's the sample data, thanks

DECLARE @MeterReading TABLE

(

MeterId int,MeterDescription varchar(100), ReadingOn datetime, NewReading float

...

Hi

The date format is 2016/02/11 07:56:15, and I need to subtract 2hrs from the time, using the expression from my previous post.

thanks for the response.

How do I create a string parameter? another thing I do have to create linked servers cause this server are hosted by my client. I use vpn...

thank you so much, it worked!!!

hi

I wonder if you can still help me. I've modified the query but not I don't want to hard code in my above select.

the reason I hard coded it is...

hi again

you are such a star, I can kiss you right now.

thank you so much the query did exactly what I was looking for.

regards

hi SSCrazy

thanks for the quick response, i'm gonna try it now.

thanks

hi Lowell

thanks for the quick response.

the query I use to get the list of all the databases is

SELECT s.name FROM sys.sysdatabases AS s

I want to automate this query...

i don't think i understand, in the execute sql task i created the command SELECT MAX(wwoq.StatusChangedOn) AS MaxDate

FROM wrkWorkOrders AS wwo

...

i'm going to create different sources but on each i need to select values withing the date range variable i'm declaring in the beginning.

thank you Phil for the quick response

i've managed to find the error after going through my script task over and over again and found that i didn't assign the variable...

SSCray and Cadavre

you guys are rock stars!!! it working perfectly

thanks