Sorry Phil. I was trying to apply your example to mine but i'm still having trouble trying to build what you said. Can you give me an example so i...

Many thanks but i can't seem to work with my own query. Below is the original query which results in

EmpID | TimeDuration

zz1 | 2700

zz2 | 2500

zz3 | 2000

SELECT ...

Many thanks. Much appreciated

P.S. What's dtTimes (Alias / Derived table) ?

Thanks guys, that works great.

Hi John,

Here is what i've tried so far. I've been googling all day but not getting anywhere

SELECT CAST(SUM(TB1.TimeDuration + TB2.TimeDuration) AS int) AS Total

FROM ...

My Mistake - Just checked the Chips in WinAudit. It is actually 2 Quad Core Processors. Whew!!!

That is perfect and amazing. I would have never achieved that. I've been looking all over the net for some examples.

Thanks again man. That's magic

Just tried it again but it seems to be getting caught up in himself or maybe i am going bonkers 🙂

The columns exp_high, exp_med, exp_low, exp_none etc. are bit...

Thanks dude. That works and rocks! Going through it now to save it in my brain 🙂

Can someone tell me can i create a new instance with one copy of SQL2005 on one server?

If so, how do i do this?

Thanks

I have only 1 SQL Server so does that mean i have only 1 instance?

Therefore is it not possible to do what i am trying to do using instances?

Thanks Andras.

Is there another way i can do this or is just not possible

Thanks