Hi and welcome to the forums. You have a challenge here because the standard recursive CTE will not work because you have multiple roots. This is often referred to as...

Hi and welcome to the forums. For this query you will need to use COUNT and GROUP BY.

If you want more specific help with the actual code you will need...

todd.ayers (5/14/2013)

---

Well, I have tables in access that I am wanting to put into the SQL server so that I can use Access as the Front End and SQL Server...

This sounds a lot like the scripts section that already exists. It is over there on the left right under the Forums link.

baseehkhan (5/14/2013)

---

Hi all,

I need to generate the financial week but in my case the starting month of the financial week ill get change for that...

Abhijit More (5/14/2013)

---

How do you want us to help? - need help to optimize the query.

Can you drop this proc and never use? - not possible

If not, what...

Don't you mean before linking your SQL table to Access?...

asaini (5/13/2013)

---

I actually had over 1000 sales orders so adding them individually would be a pain but Sean, thank you so much! Your count(invoice) section did the trick. I just...

That...

Lowell - you win this time. 😉

asaini (5/13/2013)

---

Sorry about that, this is an idea of what I have:

Sales Order #InvoiceIDInvoiceDate InvoiceAmount

SO-100 INV-382224/12/2013 ...

skb 44459 (5/13/2013)

---

There are 5 tables we have which has a parent child relation we have following tables.

Order (Fields Order#, RefType, RefNum, RefLine)

OrderLine...

William Gary Wright (5/13/2013)

---

I work at a 911 center. Our data is sensitive and proprietary. I also have a contract with our software vendor to not disclose any information about...

Randy Doub (5/13/2013)

---

The cursor works. The max(tx_id)+1 does not get incremented when you comment out the insert and just display the results.

So I'm not crazy or lazy using a...

asaini (5/13/2013)

---

I am having some trouble coming up with a query to do this. I want to distinguish the unique/distinct invoices I have under the same sales order. So for...