Alvin Ramard (6/18/2009)

---

Dugi (6/18/2009)

---

Alvin Ramard (6/18/2009)

---

Exactly!

A great apple should be better than a bad...

Yep nice solution here without UNION! Nice analyzing Chris!

And your vote goes for ...? - http://www.sqlservercentral.com/Forums/Topic737392-61-1.aspx

Alvin Ramard (6/18/2009)

---

Exactly!

A great apple should be better than a bad grapefruit and a...

Grant Fritchey (6/18/2009)

---

I wouldn't even call it apples & grapefruit. I'd say it's apples & chairs that you're comparing. Good luck sitting on the former or eating the latter. MVP...

thetodaisies (6/18/2009)

---

Hey,

please try this. the union is used to get the last record which wll not be returned in the first query

select a.* from

(select ROW_NUMBER() OVER (ORDER BY...

Yes, correct also I tried to order by item now is correct! But if you compare the first result set with the last one no the same results.

I can not see where did you change your code in your last post but again no same results as simon wants !!!

As I can see and little bit analyzing...

_simon_ (6/18/2009)

---

Hey, of course this are sample data 🙂

Maybe this is better representation of actual data:

if object_id('tempdb..#temp') is not null drop table #temp

create table #temp (item varchar(10), price1 money, price2...

Ok, here is just the poll and results what others vote for!

And your vote is ...? - I'm sure that will be the MVP -...

Christopher Stobbs (6/18/2009)

---

Here is a solution that will work for Multiple Image types:

CREATE TABLE MyTable

(Id INT,

CustomerId INT,

ImageName VARCHAR(100))

INSERT INTO MyTable

SELECT 1,123,'123_X.jpg' UNION ALL

SELECT 2,123,'123_Y.jpg' UNION ALL

SELECT 3,456,'456_X.jpg' UNION...

Pyay Nyein (6/18/2009)

---

try this one..

SELECTItem, price1, price2, date

FROM#temp

WHEREdate = (select max(date) from #temp)

UNION

SELECTdistinct T.Item, T.price1, T.price2, (case when (T.price1 = C.price1andT.price2 = C.price2) then C.Date else t.Date end)

FROM#temp...

GilaMonster (6/18/2009)

---

MVP is not a certification. You can't directly compare it to the MCM, MCA certs. Plus, there are only (iirc) 3 MCM certs available - Exchange, sharepoint, SQL Server....

No the output results are very unknown and no sense why these results...more explanation if you want the correct solution for what you are looking!

:hehe::w00t::hehe:

I don't like triggers very much and try to keep them away if possible

I agree with Florian ...but sometimes they are very nice objects to control (delete, insert or update)...