I was able to use an ISO Week function, then just subtract the week number of the first of the month....add 1 to that and come up with my result...

Performace Guard (Shehap) (10/12/2011)

---

You could run the below query :

select JB.ID1, JB.ID2, JB.stat,JB.item,JR.oper_num, JR.complete, JR.qty_complete,max_date

from TABLE1 JB

join TABLE2 JR on JB.ID1 = JR.ID1 and JB.ID2 = JR.ID2

inner join (

select...

I can't seem to get it to translate to my actual tables (I thought I could use Northwind as an example - but it's not quite the same)

use [tempdb]

go

CREATE TABLE...

nitin1309 (10/12/2011)

---

I dont know if I get this right:

You said

"and this is my query2:

SELECT Orders.CustomerID, customers.companyname, max(Orders.ShippedDate)

FROM Orders INNER JOIN

Customers ON Orders.CustomerID = Customers.CustomerID

where Customers.Country='usa'

GROUP BY Orders.CustomerID, Customers.CompanyName

I want query...

R.P.Rozema (10/12/2011)

---

I haven't tested it (I don't have nw installed), but this should do what you need using a sub-query construction. You can also use the window-functions (f.e. row_number()) to...

nitin1309 (10/12/2011)

---

Good example of what I just told you:

http://riteshshah.wordpress.com/2009/03/03/use-of-rank-and-partition-by-clause-in-sql-server-2005/%5B/quote%5D

I didn't sleep at all last night so I'm not able to even comprehend that today. To put it...

Only in easier examples than this. Not sure how to do it here.

My mistake - when I was translating everything back from the generic code I had a typo - all is good. Thank you - that was EXACTLY what I...

Thanks Sean - that's almost there! For some reason it's cutting off the first digit in that new column. (e.g. 16 is showing as 6 for me)

If you take that query - what I need is third column that shows the first value that is in the concat field (the one with the "stuff" command).

Thank you GSquared!

I still need help. I was working on finding the first value of a field and then concatenation all values for that field. I am able...

Again - it's been a tough day so please go easy on me.

I've revised what I want:

create table #temp

(

ID nvarchar(20),

...

I tried code that someone else posted (but has now deleted). The code above does work. Thank you!!! (I just hadn't read that far when I tried...

For some reason that's just returning every row. Any other ideas? How about first location by alpha?

ok - just found a column with unique values that we could use. Let's call it COL3 (ADDED UP IN FIRST POST)