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

Read today's article. It is part 3 in a series about auditing.

What would be far better than a spreadsheet is to post ddl (create table statements)...

The first suggestion I would make is to leave formatting to the front end. Put this in SSRS and let the formatting go crazy. I would certainly not recommend using...

Did you commit or rollback the transaction? Sounds like blocking to me.

I am guessing you didn't read that article as most of this is pretty useless.

The create table portion is ok but...

OK I will try one last time. You keep saying you want to auto-populate this table. I understand the table and relationship but I don't understand the logic of how...

You are going to have to explain this clearly. You just keep randomizing stuff. I am not familiar with your project and your explanation is leaving me scratching my head....

nu_bie (5/30/2012)

---

I just random the data. This case is all about auto populate table. So, based on table Performance and Performance_Rating, i need to auto populating table Performance_Rating_Validity, which is...

You are quite welcome. Glad that worked for you.

nu_bie (5/30/2012)

---

Hi Sean,

Yes thank you for editing my SP in populating Performance table. It was succeed when I run the SP on my SQL Server 2008 but when I...

Koen Verbeeck (5/30/2012)

---

Sean Lange (5/30/2012)

---

This one could be disqualified because it is...