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

There are plenty of people willing and able to help. The main reason nobody has helped yet is...

tilew-948340 (5/29/2012)

---

I need to move a DB from SQL server 2008 R2 on a Window7_64 machine to a WindowXP_32 (not sure that the machine would survive to an update to...

sql server developer (5/29/2012)

---

CREATE TABLE dbo.TestAsset(AssetID INT IDENTITY(1,1) PRIMARY KEY, SerialNo VARCHAR(100))

--CREATE Filtered UNIQUE Index to allow multiple records of NULL and Unique non-null values in serialNo column

CREATE UNIQUE NONCLUSTERED...

Some of the best learning comes through teaching. This has never been more true to a profession than sql server. The topic is so huge that nobody can master the...