Marveloid

depends on how you want to display the data? average and max per what? per hour, day,week month? post in some table definitions and data and exactly what you want...

kerching $$$ Steve got any jobs 🙂

Methodoligy

I have used this site a fair amount to help me with my SQL knowledge and i want to help others like I have been helped. Also when I get...

no trouble mate

ok its late but this is what i see you have 2 inline tables an you are then innerjoining on those table therefore your result set would be that of...

i get the same issue if with SQL server 2012 where it replaces ABC but not Abc, aBc ir any other combination here is how i overcome it

REPLACE(upper(TestVal),'ABC','XYZ')

can you paste in your full query, also do you have a where clause as this can be a root cause to negating a left outer join

Subqueries are less efficient than a join...

i think you need to define what is a successful record as i understand what you are asking for is what we have all completed and that is to check...

Can you paste in your logic and we may be in a better position to help you However,

have a look at this CTE from your explanation of the table this...

@sridhar_kola i must say im in agreement about how to work out where the 2 hours comes in:w00t:

hi im not 100 % sure on what your asking and what you expect in results, looking at your example table there is nothing to filter down on you can...

Why not add in some DDL and then add what you want to achieve and we can help you. here is a useful ink on CTE http://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/

you could...