weisen678 (5/31/2012)

---

Sean,

I am quite new to SQL.

but at the begining, I have said, this is my study project, so, the tables are my real enviornment. there are three tables,

product...

No problem. I am about to wrap up for the day too.

dallibabs (5/31/2012)

---

🙂

The script above works fine and returns the results I need for one category (73) but I would like the results for lots of categories so instead of just...

I don't quite follow what you are trying to do but I suspect that what you have here is pretty close. You can change that select to be a an...

Also, become very familiar with the online documentation. It contains the answers to nearly everything you need to know, or maybe didn't know you need to know.

Here is a link...

Hi and welcome to SSC and SQL in general. You have stumbled upon arguably the best resource for learning this topic you can find anywhere. Download a copy of sql...

Lynn Pettis (5/31/2012)

---

Sean Lange (5/31/2012)

---

Lynn Pettis (5/31/2012)

---

Here is my problem with Natural Keys (not saying they are wrong), they tend to not stay unique. Your case in this thread...

Lynn Pettis (5/31/2012)

---

Here is my problem with Natural Keys (not saying they are wrong), they tend to not stay unique. Your case in this thread is a good example....

kramaswamy (5/31/2012)

---

@Lynn - that was actually something I was thinking about too, for that exact reason. As it stands I'm going to have to modify the other tables one way...

Lynn Pettis (5/31/2012)

---

Sean Lange (5/31/2012)

---

kramaswamy (5/31/2012)

---

hey all - got a theoretical question.

I see three ways of going about solving this problem:

1. Keep ClientID as the Clustered Index, but remove the...

I just googled "ssis vb.net tutorial" and get over 200,000 hits. The first page all look good sources of information. One of which is a link from this very site...

This is not...

You're welcome. Glad that worked for you. The code I shared will get everything for a given category. Not sure what else you are looking for but let me know...

You're welcome. Closing SSMS closed that connection and therefore implicitly rolled back your transaction. 😀

Well done posting ddl and sample data. Had a couple typos but not a big deal.

In order to do what you are trying you need to use what is...