What approach are u following to split, currently ?

How about this?

SELECT Item,

Location,

...

This is the requirement right ??

So, it is correct to delete the rows with multiple...

Or this>

delete from #Temp

where OrderID IN

(

select T.OrderID

FROM #Temp t

GROUP BY T.OrderID

HAVING (COUNT(*) > 1 AND COUNT(T.OrderID) <> COUNT(T.City))

)

Can NOT be done as u were saying ; WHERE clause filters ROWS, not COLUMNS. You will have to manually write the required columns in the SELECT list.

Else, if the...

LutzM (3/5/2011)

---

ColdCoffee (3/4/2011)

---

...

Hmmm, yeah , Lutz ; But i and Jeff can meet as we are in the same continent 🙂 I am in the US for an assignment. I...

Jeff, got my mail?? (Gentle reminder to Jeff as his PM box if full; apologies for spamming in other's thread :pinch:)

Jeff Moden (3/4/2011)

---

As a side bar, Lutz, CC and I make one hell of a tag team with no sense of "one-up-manship". It would be a joy to work...

This probably is the fastest i could think of 🙂

select d.EmpNO ,

stuff( (replace ( ',2001,2002,2003',cast( (

...

Jeff, can u please delete some of your old PMs; when i tried sending u one PM, it said the recipient exceeded the number of PMs. Just wanted to inform...

:cool::-P

LutzM (3/3/2011)

---

Something like this? (assuming the table is called #t and the column is col)

;

WITH cte AS

(

SELECT col,

CAST(STUFF(col,1,1,'') AS INT) - ROW_NUMBER() OVER(ORDER BY col ) AS grp

FROM ...

Lol :w00t: !! my nickname is derived from a bitter experience by drinkng ColdCoffee, but that led to the formation of a set of close friends for me; so, me...

Will i be getting a Samsung Focus for this help , mate ?? :hehe:

smarty3010 (3/3/2011)

---

I found a query to select nth row....

SELECT column/s FROM

(

SELECT column/s, row_number() over(ORDER BY getdate()) as...