conversion of SQL Server 2008 stored procedure to Oracle 10g
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

Answer Question   |  May 15, 2012  7:54 AM
Oracle 10g, SQL Server 2008, SQL stored procedures

Modifying a Stored Procedure
The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don’t want it showing up on the [...]

Answer Question   |  June 9, 2011  2:31 PM
Crystal Reports, SELECT statement, SQL, SQL Database, SQL stored procedures, Stored Procedures

Related to SQL server 2005
When we write store procedure it is encrypt by –with encrypt tag means it will locked it doesn’t show sp so how it will be DECRYPT?

Answer Question   |  June 10, 2011  4:39 AM
Decryption, SQL Server 2005, SQL stored procedures, Stored Procedures

Create a database in SQL Server 2005
Create a database in sql server 2005 but database name passed as parameter into a stored procedure

Answer Question   |  March 7, 2011  7:05 AM
SQL Database, SQL Server, SQL Server 2005, SQL Server database, SQL stored procedures

Stored Procedures in SQL Server 2005
Will you please explain me about Stored Procedures in Sql server 2005

Answer Question   |  January 13, 2011  4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures

SQL Server 2005 procedure to Create stored procedure
sir,plz tell me the procedure from strating that how to create stored procedure

Answer Question   |  December 11, 2010  11:19 AM
SQL 2005, SQL Server 2005, SQL Server stored procedures, SQL stored procedures

Example of Cobol call to an SQL stored procedure
I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName [...]

Answer Question   |  December 3, 2010  6:05 PM
COBOL, iSeries, iSeries Cobol programming, SQL stored procedures, Stored Procedures

How do I modify stored procedures in sql 2005?
Where can I view in SQL 2005 when a stored procedure was run and what its outcome was? Can I see who ran it? Can I see who modified the job?

Answer Question   |  October 23, 2010  5:28 PM
SQL 2005, SQL stored procedures

Row by Row Stored Procedure in SQL Server 2008 R2
Hi All, hopefully someone will be able to help me here – i am nearly there but can’t get it right, i am trying to create a stored procedure that when runs will do a query and then send send an email out for each of the rows that it returns. e.g. if i have [...]

Answer Question   |  October 4, 2010  1:36 PM
SQL, SQL Server 2008, SQL Server 2008 R2, SQL stored procedures, Stored Procedures

Receiving result sets in RPG (prior to release 7.1) from an SQL SP
I have read through the IBM manual “Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries” for information related to returning a result set(s) from a stored procedure into an RPG program. The manual states that a Global Temporary table must be used for this as it cannot access the result set [...]

Answer Question   |  August 26, 2010  5:45 PM
i5, RPG, SQL, SQL stored procedures, Stored Procedures

Exclude Login from SQL Audit Trace
I’m working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I’m using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login from being audited?

Answer Question   |  August 16, 2010  6:06 PM
Audit Trace, SQL audit, SQL Server, SQL Server 2005, SQL stored procedures

Set DataTable name in returned data set
I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,…  when the dataset is received on the .NET side.  Is there a way to define [...]

Answer Question   |  July 20, 2010  3:29 AM
C# .NET, DataTable name, iSeries SQL, SQL stored procedures

SP Dynamic SQL with LIKE Operator
Hi. I want to create a stored procedure whereby the variable comes after the LIKE operator. For example, the code would look something like this: CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR SELECT * FROM TABLE1 WHERE FIELD1 LIKE ‘%@VARIABLE1%’ Then to execute the procedure, EXEC SPFIND ‘VARIABLENAME’ I can’t get this to work using the LIKE [...]

Answer Question   |  June 8, 2010  12:38 PM
Dynamic SQL, SQL Server 2005, SQL stored procedures, Stored Procedure variables

SQL DTS package scheduling
When a DTS package is scheduled to run at a specific time of day, is it done through the use of a stored procedure or a job?

Answer Question   |  December 8, 2009  1:53 AM
DTS package, SQL Jobs, SQL stored procedures

How to encrypt a big list of sp’s at once
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn’t be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I’ll like to know if there is a way [...]

Answer Question   |  November 18, 2009  7:52 PM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization

STORED PROCEDURE
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it  

Answer Question   |  October 21, 2009  5:14 AM
DB2, SQL stored procedures, SQL/400

execute as with synonym
This is a good one, I have a stored proc in database A that first deletes some rows from a table in database A. it then does a delete from a synoym that references a table in a different database. We were trying to use a “execute as” with a windows sql account “domainsrvc” that [...]

Answer Question   |  August 11, 2009  3:45 PM
SQL Database, SQL stored procedures, Stored Procedures

Error inserting into table with identity column
I have 2 stored procedures. Both insert records into table variables, and each of those table variable has an identity column. One procedure executes and the other gives an error telling me that I am explicitly trying to insert into the identity column (which I’m not). Here is the code from the 2 procs: This [...]

Answer Question   |  May 30, 2009  6:33 PM
SQL 2000, SQL stored procedures, Stored Procedures

Deadlocks and Conflicting resources
I have a program that loops through a temp table, and for each row looks up a value in another table, and depending on the result returned inserts a record into one of two tables. Some days this takes 10 minutes to run and others it takes 2 hours to run. There are no other [...]

Answer Question   |  May 13, 2009  1:52 PM
SQL Server 2000, SQL stored procedures

Stored Procedure
Hi Guys. Any help would be greatly appreciated. I have three tables Table 1 ID PurchaseOrderNo Value Table 2 ID PurchaseOrderNo WorkID Table 3 WorkID Cost Tables 2 and 3 have a many to one relationship with table 1. I want to display all the PurchaseOrderNo from table 1 and then the sum of Costs [...]

Answer Question   |  April 27, 2009  3:15 PM
SQL stored procedures, Stored Procedures