Viewing 15 posts - 2,446 through 2,460 (of 3,221 total)
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...
September 7, 2009 at 5:12 pm
Do you have the ColdFusion debugger?. If so you can track the variable in ColdFusion to see it the problem exists within ColdFusion.
September 6, 2009 at 8:51 am
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...
September 2, 2009 at 6:18 pm
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,...
September 2, 2009 at 2:53 pm
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
September 1, 2009 at 5:24 pm
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...
September 1, 2009 at 9:36 am
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...
August 29, 2009 at 7:29 am
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...
August 29, 2009 at 6:58 am
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...
August 27, 2009 at 10:40 am
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
August 27, 2009 at 10:19 am
willferguson
OK so how do I get the connection string to change dynamically
The Data Link Properties form is inter-active. The user selects
1. a server from a drop down list
2. A...
August 26, 2009 at 12:15 pm
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...
August 26, 2009 at 10:46 am
anil
the statement below is same for sql server 2005
DECLARE @i AS INT
.
.
set @i =100;
.
.
SET @i =@i +25;
The difference in the statementl are:
DECLARE @i AS INT = 100 which...
August 26, 2009 at 10:08 am
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...
August 25, 2009 at 6:24 pm
Viewing 15 posts - 2,446 through 2,460 (of 3,221 total)