Yes it's a data source for an Excel Pivot Chart. I'm trying to show a timeline of certain server performance metrics.

This allowed me to format the date how I would...

I'm getting the data from Microsoft Performance Monitor. The date field is not a date field

If I sort the data...

I give up. Even if I manage to display it correctly, it's not treating the field as a timestamp so ordering gets all messed up.

Figures a Microsoft logging application would...

I'm getting closer. Now my only problem is the time field is displaying in 24h instead of 12h. Any ideas?;

ChrisM@Work (1/2/2014)

---

Rando (1/2/2014)

---

Still searching for a solution. Scott's solution yield's syntax errors and Chris' solution yields the entire date field...

Again, I'm just looking for the results to be the following;

Date:...

Still searching for a solution. Scott's solution yield's syntax errors and Chris' solution yields the entire date field...

Again, I'm just looking for the results to be the following;

Date: 12/30/2013

Time: 01:00...

All records in the table came back :hehe:

That's where I run into the syntax error;

Msg 241, Level 16, State 1, Line 1

Syntax error converting datetime from character string.

Thanks guys, this works but is it not the desired output format.

I can't change the table column formatting from char to datetime because it is automatically created by Microsoft...

Thanks. I'm not able to test this yet since they took our server down today and are migrating it to a different server.

I've never seen SQL like that before....

Create Completed Table

CREATE TABLE pt_Completed

(ID int not null PRIMARY KEY IDENTITY,

MainFunction_id smallint not null,

SubFunction_id smallint not null,

UserID int not null,

AssocID char(8) not null,

RACF varchar(10) not null,

Name varchar(50) not null,

Completed int...

bteraberry (6/9/2010)

---

Your Breaks is the sum of...