San (7/16/2008)

---

San, do you have any more information regarding this puzzle? For instance, are you aiming to change an existing table to meet your criteria, or to return a satisfactory...

San (7/15/2008)

---

Hi

I am sorry if someone has already posted this question and am asking again.

This problem is eating my head, I have a table

Table 1 -

1br

1er

2rt

3yh

2uj

3iu

3ol

Now I want only...

Interesting solution - care to elaborate?

You will need to provide much more...

Something like this?

CREATE TABLE #ContactDetails (ContactID INT, ContactMethod VARCHAR(5), ContactDetail VARCHAR(30))

INSERT INTO #ContactDetails (ContactID, ContactMethod, ContactDetail)

SELECT 1, 'Phone', '+1 413 2220144' UNION ALL

SELECT 1, 'Fax', '+1 413 2221144'...

harshil (7/8/2008)

---

Hi Jeff, In this query, the condition is rightly mentioned as rowno>1 and shouldn't be rowno=1

What the purpose of this query is to remove all duplicate records except one...

harshil (7/8/2008)

---

Yes Mr. Actually I have read the requirements and I have correctly suggested the intended solution to delete duplicate records.

Although I have intentionally mentioned it for SQL SERVER...

DECLARE @t nvarchar(16)

SET @t = 'T5e3st003'

SELECT RIGHT(@t, MIN(number)-1)

FROM Numbers

WHERE SUBSTRING(REVERSE(@t), number, 1) NOT IN ('1','2','3','4','5','6','7','8','9','0')

AND number < 10

DROP TABLE #test

CREATE TABLE #test (t nvarchar(16))

INSERT INTO #test (t)

SELECT 'T5e3st003'...

A single statement?

SET @T = '03' 😉

Or perhaps

SET @T = REVERSE(LEFT(REVERSE(@T),2))

Or even

SET @T = substring(@T, 6, 2)

All of these (and Gail's solution) will give the result "03". Is...

Two hours & three trains each way: Reading -> Virginia Water -> Weybridge -> Surbiton (Reading -> Basingstoke -> Surbiton as backup route). WFH two days a week so it...

How many rows are returned by this...

SELECT a.casenum, a.at_id

FROM #audit_trail a

INNER JOIN (SELECT MAX(at_id) AS at_id, casenum FROM...

d_sysuk (7/2/2008)

---

Hi Saritha,

Think you may have made the first initial mistake that I did, (whilst was determining what the poster required - as was not the clearest)..

Background

Table: Has dup rows

Requirement:

Delete...

saritha (7/2/2008)

---

Try this

set rowcount 1

select 1

while @@rowcount > 0

delete Emp1 where 1 < (select count(*) from Emp1 a2

where Emp1.Eno = a2.Eno

...

Read the friggin' spec 😛

Thanks for pointing that out Barry. This solution will only work if the data is ordered...