Thank you..

Hi,

See this article..

http://www.sqlservercentral.com/columnists/ccubley/findinganddeletingduplicatedata.asp

Cheerz

K.Senthil Kumar

Hi All,

This is my questions. Pl. ignore the previous one.

These are the records  I've in my table.

I need to return top 3 countries (rank) by Sales.

Record            Date                Country          Sales

1                   ...

Ok. My Table Structure is :

Product Code

Part#

Replacement Date

Replacement Qty

I Result should be

Product Code    Part#  Month(Replacement Date)   Qty

CL001              5001   Jan'04                             10

CL001              5002   Jan'04                             12

CL001              5001   Feb'04                             25

CL001              5002   Feb'04                             26

Note: In the table the 'Replacement Date' has 'dd/mm/yyyy' format 

thx

Senthil

Hi,

See this article.

http://www.sqlservercentral.com/columnists/ccubley/findinganddeletingduplicatedata.asp

good Luck,

K.Senthil Kumar

Thank you guys, for your help.

Cheerz,

K.Senthil Kumar

Hi Beulah Kingsly,

Thx for immediate reply. But dbo.fnGetRemarks function will return only 200 charaters only rgt? I can't give fixed length return value.

Coz, I'm having so many records. Then try to change the...

Hi

Use DATEDIFF function.

SELECT * from Employee

from employee

where

DATEDIFF(Hour, Begin_Work   ,    End_Work) >= 1