try this:

SELECT ac.Month,

MAX(CASE WHEN ac.WeekNum = 1 THEN ClearedCount ELSE NULL END) AS [Cleared Cases on First Week],

MAX(CASE WHEN ac.WeekNum = 2...

This should do what you are looking for:

SELECT a.AssignmentDate, a.CustomerID, c.CategoryName

FROM

(SELECT CustomerID, ActionID, AssignmentDate,

ROW_NUMBER() OVER (PARTITION...

josephptran2002 (11/26/2008)

---

Set DATEFIRST 6 --Since I wish to start counting records on saturday to Friday of every week.

SELECT COUNT(ClearedDate) AS 'Month',

...

...more specifically, are you expecting each category to be in a separate record in the resultset or are you expecting them all to be in the same row? (pivoting) ...

lk (11/26/2008)

---

...Is there a way to identify which records in Demographics have been changed, and to overwrite those with the new data in DBX? The only solution I can come...

josephptran2002 (11/25/2008)

---

Select Count(ClearedDate) As 'Total Cleared'

from DEClearedDate

Where (Datepart(dw,ClearedDate)>=1) And (Datepart(dw,ClearedDate)<=6)

The script that I wrote above gave me

Total Cleared 24 records have been entered. But I wish to have it...

Actually I could see it going either way....

I've never had to use FORCE ORDER in SQL Server, the engine does pick the most efficient order in the work that I've done. I only mentioned it because...

If you want to stick with using PIVOT, you need to explicitly list the values you want to "horizontalize" which are the month numbers. Try this:

select * from

...

looks like you've just got to change the last step to:

EXEC('SELECT TOP (100) PERCENT LIBID, COUNT(*) AS count INTO [dbo].[' + @temporary + '] FROM dbo.tq_old_lib_ids GROUP BY LIBID');

the INTO...

Ravi (11/21/2008)

---

Table structure

Item Master

------------

ItemID BIGINT NOT NULL IDENTITY(1,1) PRIMARY KEY,

ItemName VARCHAR(255),

QOH NUMERIC(18,2), -- Quantity on Hand

ROL NUMERIC(18,2), -- RE-ORDER LEVEL

DATECREATED DATETIME NOT NULL DEFAULT(GETDATE())

Item Issue Master

IssueID BIGINT NOT NULL IDENTITY(1,1)...

eric.lam (11/20/2008)

---

But ... what I want to do is to reduce the number of rows returned, with 2 additional requirements ...

AND T.PERTYPE = 1

AND T.PERDATE = '20090630'

The thing is, I...

If the REPLACE method has performance issues, another option may be to put the added space inside the ISNULL:

Ltrim((isnull(ACTION + ' ','') + isnull(QUANTITY + ' ','') + isnull(UNITOFMEASURE +...

First, I'm not sure why you're doing the COALESCE RTRIM LTRIM on @station_list 3 times, and since @start_date and @end_date are smalldatetime, it wouldn't make sense to try to set...

Marco André Duarte Francisco (11/20/2008)

---

The query is this:

SELECT

H.*

FROM QS10H_ACTIVIDADES H WITH(NOLOCK,INDEX(U_QS10H_ACTIVIDADES))

INNER JOIN QS10F_ESTADO_ACTIVIDADE F WITH(NOLOCK) ON (H.ID_AVARIA=F.ID_AVARIA)

QS10H_ACTIVIDADES is a table...