You may want to examine the grouping of your stored procedures using this group of create statements.

CREATE PROCEDURE my_Proc_Name;1

AS

SELECT some column from some table

GO

CREATE PROCEDURE my_Proc_Name;2

AS

SELECT some other column...

Do you have the ColdFusion debugger?. If so you can track the variable in ColdFusion to see it the problem exists within ColdFusion.

riga1966

I took the liberty of adding a few additional entries to your sample data, and assumed that you meant 5 consecutive business days. I did not develope code...

Shortened up the list of columns but this select works, just addin all the column names that I skipped over to make testing quick and easier.

INSERT INTO dbo.pedidos ([PedNum],[ESTID])

select PedNum,...

Use books On Line (BOL) the sQL" Server help file and read up on the ccommands EXECUTE and SP_EXECUTESQL

Execute

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bc806b71-cc55-470a-913e-c5f761d5c4b7.htm

sp_executesql

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/01c64ab0-9227-475a-a59a-ed80f9333042.htm

Further read in BOL about sub queries

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9c1d634c-fc9f-42e8-ae6f-20b350ef5c90.htm

Here is a script posted to SSC by Ofer Bester - all you need do, is a bit of copy and paste and you have what you want

http://www.sqlservercentral.com/scripts/Miscellaneous/30094/

I have used...

Refer to Books On Line (BOL) at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/0a760138-460e-410a-a3c1-d60af03bf2ed.htm

The above page provides an example T-SQL statement to do what you want to do.

Be careful changing the schema may invalidate previously written stored...

albertvanwyk

Without additional information it will be difficult to assist you in any meaningful manner. For example:

a. How are risks rated, what makes one risk...

Hickshugh

Try this link

http://northtexas.sqlpass.org/

Bullfrog

You are likely to get help if you click on the link in my signature block and read and follow the simple instructions as how to post to assist those...

Use Books On Line and lookup the Date and Time Functions (Transact-SQL)

and read this

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

The Data Link Properties form is inter-active. The user selects

1. a server from a drop down list

2. A...

ifila

Have you entered "injection attacks" in the search box at the upper right hand corner of this forum page, and the read some of the articles? If so...

The difference in the statementl are:

DECLARE @i AS INT = 100 which...

The connection string I utilized to attach to a SQL Express 2005 database is

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TIPSnTRICKS;Data Source=substituteyourclientsmachinename\SQLEXPRESS.

You might want to consider including in your application a...