just need to add in the nessesary date parts

select CONVERT(NVARCHAR,(DATEPART(HOUR,getdate())))

select CONVERT(NVARCHAR,(DATEPART(MINUTE,getdate())))

What do you get when you run DBCC CHECKCATALOG in the DB?

You need to group by ALL columns which are not contained in an aggregate function.

This is cleaver marketing, they are not actually asking for the test engines,...

Sounds like a case of UAC getting in the way. Is it disabled on your machine?

your missing a GROUP BY clause

Are you using UNC paths or have you mapped a drive to the network share?

Cadavre (5/25/2012)

---

First, this is how you should post your sample data: -

SELECT WorkId, WorkName, CurrentStatus,

ActualStartDAte, ActualEndDate, ParentWorkId

INTO #yourTable

FROM (VALUES(100,'Define','Proposed','25-05-2007','26-06-2008',100),

...

You will need to pivot or cross tab.

There are two links in my signature to cross tabbing, also if you follow the second link in my signature on posting code,...

sys.dm_exec_sessions will give you that information, except numeric_roundabort, cursor_close_on_commit and implicit_transactions, just digging into where these would be.

It would call for the distinct or group by clauses to be added to your query in order to ensure that each row is unique in the result set.

You could...

If there...

So we can expect you to have tinnitus next week then Koen?

Jealous springs to mind right now.

I usually go to Download festival here in the UK every June, but not this year due to starting a family, so I'm gutted but...

Koen Verbeeck (5/25/2012)

---

Schadenfreude-Mei (5/25/2012)

---

Koen Verbeeck (5/24/2012)

---

As long as you keep all those grunge...