Jeff Moden (8/23/2013)

---

Sean Lange (8/22/2013)

---

Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit....

Eugene Elutin (8/23/2013)

---

No need in windowed functions, you can achieve the same by simple ORDER BY of UNION ALL:

SELECT ItemName

FROM (SELECT *

FROM ...

wolfkillj (8/23/2013)

---

Sean Lange (8/23/2013)

---

SQLRNNR (8/23/2013)

---

Sean Lange (8/23/2013)

---

SQLRNNR (8/23/2013)

---

Koen Verbeeck (8/23/2013)

---

ChrisM@Work (8/23/2013)

---

GilaMonster (8/23/2013)

---

Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to...

Thanks. Having ddl and sample data makes this a LOT easier. 😀

Something like this should work.

with SortedItems as

(

select CategoryID, CategoryName, ROW_NUMBER() over(order by CategoryName) as RowNum, 1 as SortOrder

from Category

union...

Just reposting the...

SQLRNNR (8/23/2013)

---

Sean Lange (8/23/2013)

---

SQLRNNR (8/23/2013)

---

Koen Verbeeck (8/23/2013)

---

ChrisM@Work (8/23/2013)

---

GilaMonster (8/23/2013)

---

Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few...

Knives85 (8/23/2013)

---

Hi Sean

That wont work. The course name has AS or A2 at the front so joining on game wouldn't help, same goes for level.

I gave the output as...

The query I posted seems like it is really...

SQLRNNR (8/23/2013)

---

Koen Verbeeck (8/23/2013)

---

ChrisM@Work (8/23/2013)

---

GilaMonster (8/23/2013)

---

Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.

We were thinking...

Your posted output doesn't seem to match the sample data you posted but I think you only need something like this???

select *

from #cteCourseAttendance ca

left join #cteCourseConversion cc on ca.CourseName...

Pretty sparse on the details but maybe something like this is what you are looking for?

Select 'Category1', Item, 1 as SortOrder

from Table1

union

Select 'Category2', Item, 2 as SortOrder

from Table2

order by...

Excellent job posting ddl and sample data. This produces the output as stated.

select Purchasing_Doc_Num, Purchasing_Req_Item_Num, min(Delivery_Ind) as Delivered

from PO_Delivery_Hist

group by Purchasing_Doc_Num, Purchasing_Req_Item_Num

I think you are overthinking what you need to post. This shouldn't take you hours and hours, it should take you minutes. I put together an example based on your...

skb 44459 (8/23/2013)

---

Here is the simplified query

select

m.trans_num ,

m.trans_type ,

m.lot

from matltran m

/*I want to find the top 1 record from same tables with...

Again we can't really help much here because we don't have any details to work with. Keep in mind that we can't see your screen. We don't know your project,...