deepakagarwalathome (10/2/2012)

---

Hi ChrisM@Work

Thanks a zillion for your response. That works fine. No problems.

A couple of questions though :-

First, whilst both 'Over Partiion By...' and the derived table sub-query do the...

ScottPletcher (10/3/2012)

---

The figures are...

sayedkhalid99 (10/2/2012)

---

i have changed the my input and output and add date and comments to make it clear, for multiple entry with in a month it shall take the last...

Koen Verbeeck (10/3/2012)

---

Brandie Tarvin (10/3/2012)

---

That would be Australia,...

ScottPletcher (10/2/2012)

---

SQL Server is optimized to do table lookups, whereas CASE statements are comparatively very slow.

Therefore, I suggest using a lookup table, as suggested by others. You absolutely want...

John Mitchell-245523 (10/2/2012)

---

I think I would create a lookup table, like this:

CREATE TABLE CodeActions (

Code char(4)

,TheActionvarchar(12)

)

INSERT INTO CodeActions (Code,TheAction)

VALUES

('ISSP','Install'),

('IECO','Install'),

('IECM','Install'),

('IESP','Install'),

('IEHD','Install'),

('ISHD','Install'),

('FRSI','Install'),

('SB42','Service Call'),

('SB4W','Service Call'),

('HD42','Service Call'),

('HD4W','Service Call'),

('SA2C','Service Call'),

('SA2W','Service Call'),

('HD2C','Service Call'),

('HD2W','Service Call'),

('SNCO','Service Call')

That way you...

Nonsense. The OP has explained that (s)he is a novice, Joe, and is willing to learn or wouldn't...

Smash125 (10/2/2012)

---

How about this one correct me if i am wrong

;WITH C AS

(

SELECT *,ROW_NUMBER() OVER(PARTITION BY Status ORDER BY Product) AS Rn FROM #TestData

),

C1 AS

(

SELECT *,MIN(Rn)OVER(PARTITION BY Status) MinRn FROM...

Smash125 (10/2/2012)

---

You are correct. Just wanted to know in one of the queries

select Product, MIN(status)

FROM MyCTE

GROUP BY Product

the second column says MIN(status) just wanted to know which...

deepeshdhake (10/1/2012)

---

Hello,

I have wrote one store proc. So, in the stored procedure, it is using one table which is in the different database. When I am trying to execute the...

Which version of SQL Server...

Change the order of your test data and see of this solution works:

DROP TABLE #TestData

CREATE TABLE #TestData

(

Product NVARCHAR(100),

Parts NVARCHAR(100),

Status NVARCHAR(100)

)

INSERT INTO #TestData(Product,Parts,Status)

SELECT 'Laptop1','mouse','OK' UNION ALL

SELECT 'Laptop1','screen','OK' UNION ALL

...

norbert.manyi (10/2/2012)

---

You could still do it as a quite...

norbert.manyi (10/2/2012)

---

Views would be a better option than functions - coded properly they won't hammer performance quite like the suggested UDF. You can't find a good example right now -...

Yes - the @ tells SQL server that the object is a variable. Your scalar UDF works with changes;

create FUNCTION [dbo].[Tester]...