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

This one could be disqualified because it is a non-alcoholic beer, or...

Koen Verbeeck (5/30/2012)

---

Why not 🙂

In Belgium we have quite a lot of recipes with beer. Never heard one...

Guinness is my personal favorite. I have had hundreds and hundreds of different beers but none seem to captivate my taste buds as well as that dark creamy goodness. I...

Oh geez...it has been awhile since I dealt with this stuff. :blush:

You have to encode your data prior to using it inside an attribute.

Try this.

<input type="text" name="MyVal" value="<%=server.HTMLEncode(request.form("notes"))%>" />