Can you post the 12 records here?

Asked and answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88616

If you compare the speed with your code above, and this

SELECT     DATEADD(HOUR, DATEDIFF(HOUR, 0, DateCol), 0) AS YYYYMMDDHH,

           COUNT(*)

FROM       WebHak_Applicant

GROUP

Why didn't you say so from the beginning?

Read my article here http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp

It has everything you need, including multiple aggregations.

CAST(STR(Date_Created) + ' ' + STUFF(STUFF(CONVERT(CHAR(6), Time_Create)), 5, 0, ':'), 3, 0, ':') AS DATETIME)

BTW, are you using SQL Server 2000 or SQL Server 2005?

DECLARE     @ToDate DATETIME,

            @FromDate DATETIME,

            @ChannelID NUMERIC(9)

SELECT      @ToDate = '01/01/2007',

            @FromDate = '01/01/2007'

DECLARE

@Sample TABLE (ID INT IDENTITY, yyyy INT,...

Change the algorithm.

When inserting, check if there is any record for same year. if there is, just add +1 to maximum NumberInYear for that year.

If a record is not found,...

SELECT

MIN(Salary) FROM (SELECT TOP 5 Salary

Yes, you can add an INDEX HINT to your query

WITH (INDEX (ix_blablabla))

SELECT      v.Number + 1 AS Hit,

            CONVERT(CHAR(5), DATEADD(HOUR, v.Number, 0), 108) + ' to ' + CONVERT(CHAR(5), DATEADD(HOUR, v.Number + 1, 0), 108) AS [Hit...

I believe that if OP is new (non-experienced) to SQL Server, he or she is better of learning the proper [ansi join] way directly, instead of learning them CORRELATED SUBQUERIES,...

No idea why the above code does not work, since I don't have access to the functions.

However, this is MUCH more efficient way to do the same thing!

SELECT

Good luck!

Most often, the CASE statements are faster than the PIVOT too, in my experience.