UNPIVOT the data to get one row per project and rep, join it to the User table to assign the display name and either use PIVOT or the CrossTab method.

If...

Very interesting article. Thank you for providing the info.

At the place I work we've had a virtualization discussion recently with the (outsourced) hardware team. They presented a concept to reduce...

Something like this?

DECLARE @t VARCHAR(40)

SET @t='Thu Aug 5 12:14:49 GMT-0400 2010'

SELECT CAST(LEFT(STUFF(@t,1,4,''),6) + ' ' + RIGHT(@t,4) + ' '+ LEFT(RIGHT(@t,22),8) AS DATETIME)

As a side note: the time zone information...

You might want to have a look at the following blog for a better performing alternative:

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx

I don't think it's an issue of the SQL Server version.

A quick google search returned this link (among others).

Did you try to connect to the database using SQL Server Management...

I'd say add another post to this thread. To pen another thread regarding the same issue doesn't make that much sense and if you'd simply edit your first post folks...

You may have noticed that there's no response yet.

One possible reason is the way the question is posted: some of us simply will skip a post if we have to...

And what is your question (assuming there is one)?

GilaMonster (6/10/2011)

I can call a horse a car, doesn't make it one. Incremental backups != transaction log...

A differential backup only holds the "information" (data, DDL, sprocs and the like) that changed since the last full or file backup. "Changed" basically means that the related transaction completed...

There is no "incremental" database backup. It's called "differential" backup.

Some folks refer the transaction log backup as an incremental log backup though....

Rest of the answer: see your other post 😉

Ouch. My fault. That's what's happening if I start posting untested code...

Go for the 2nd version I posted (using the CTE and CrossTab approach).

If you're dealing with a multi-mill table...

Glad I could help 😀

Did you verify the actual exection plan of the current solution to see if there might be an index to even speed it up further?

Regarding the...

Here are two possible scenarios. But since I don't have anything to test against regarding correct results and performance (e.g. comparing execution plans), you'd need to test both and compare.

As...

Congrats, Gail!!

And thank you for continuously sharing your knowledge!