Thanks Chris.  You are exactly right.  I didn't realize .NET would convert my date to a datetime.  Here is what I added to my ASP for that field in the...

Yeah I was looking at the same thing.  Didn't realize that the Gridview was getting the default C# format for Date which is DateTime.

Thank you for the help.

Possible.  But I can't figure out where that would be coming from.  This is all of my code to bind my grid.

   DataTable dt = new DataTable();

Thank you for the reply Thom.  I can't believe I missed that.  Well the error is gone but I still get time with date.

Do I need to change...

Thank you. I will read through that article.

Thank you Chris. 19 seconds to run that time.

The entire database is 9 MB

Good point. I used to not delete everything but when my weeks flipped, my data got messed up. I was lazy and decided to just wipe it instead...

@Thom. Thanks for cleaning up the code and making it readable. I changed the LEFT JOIN and the query is still running at 8 minutes. ...

Seems like this worked

SELECT COALESCE (n.Application, k.Application) Application

FROM Table1 n

FULL OUTER JOIN Table2 k

ON n.Application = k.Application

GROUP BY COALESCE (n.Application, k.Application)

I tried that and the NULL values still will not show up. I am joining on a different column now.

Understand joins. Didn't realize that would exclude nulls. Thank you.

Here is what I ended up doing to get this to work

;WITH CTE AS

(

SELECT

Application = t.Application,

Timestamp = CONVERT(date, t.Timestamp),

Performance = AVG(t.Performance),

Availability = AVG(t.Availability)

FROM

Table2 a

INNER JOIN

Table1 t

ON a.Application = t.Application

WHERE a.Application...

Sorry, I didnt realize the ON DUPLICATE was mysql. Should have seen that. I am using T-SQL. And I will look at changing the name of that...

If I do a separate UPDATE statement, what would I set Application and Timestamp equal to? Would I need to create a variable from the existing items and update...