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...

Depends on how much you are paying.

Then you need to close the connection that called it. That will cause an implicit rollback.

Where are you going to display this? That is where you should format it.

If you are deadset on on forcing this square peg through t-sql you need to post ddl...

This will show you the current open transactions.

select * from sys.dm_tran_active_transactions

If you still have the same SSMS window open you can see if your transaction did not complete.

select @@TRANCOUNT

I suspect...