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"))%>" />

Can you post the code that you used...

From what you posted I can't even begin to help. You have a number of tables and functions that I have no idea what they look like. Remember I can't...

Thanks for the ddl. You really don't need a loop for this insert. Use the tally table from the link I sent you and your entire loop becomes this.

create procedure...

How are you getting this parameter? Is it like a comma separated list?

<input type="hidden" name="notes" value="<%=Replace(Request.form("notes"), "", """")%>">

I think that should be close. You don't want to do that in your parameter or it will replace in the value which is not...

steveg-941384 (5/30/2012)

---

The asp code is pretty simple.

The confirmation page contains <textarea cols="40" rows="5" readonly><%=Request.form("notes")%></textarea> to properly show the double quotes within a text area. This page also...

what is the error. I think that to get days in SSRS you should use "d" instead of "day".

HI an welcome to SSC. I could help you with this but it is very unclear what you are trying to do. It looks a number of insert statements? You...

WILLIAM MITCHELL (5/30/2012)

---

according to http://msdn.microsoft.com/en-us/library/ms175098.aspx

"IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope...When the IDENT_CURRENT value is NULL (because the table has...

As stated above you need to provide some consumable ddl (create table statements), sample data (insert statements) and desired output. There is little anybody can do to help until everyone...

nigluc (5/30/2012)

---

Hello,

I need to calculate retro worked days. I have built a program to generate the worked days of a present pay period for a particular work contract. Now...