• 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  

    AS400SQL25 pointsBadges:
  • 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 "domain\srvc" that has sysadmin...

    tcstl95 pointsBadges:
  • RPGLE Stored Proc to Reporting Services

    Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message "low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

    Oldmickey65 pointsBadges:
  • 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...

    Bleeb45 pointsBadges:
  • 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 processes running against...

    Bleeb45 pointsBadges:
  • 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...

    Andy199997215 pointsBadges:
  • Shell script within Stored Procedure

    How do I execute a UNIX shell (.sh) script from within an MS SQL Stored Procedure?

    VelameLaCosa110 pointsBadges:
  • how to capture cases in store procedure codes

    I wish to creat a query in store procedure (with variables such as Start Datetime, End Datetime, Parameter varchar(3) as you can see on my store procedure for other reports). But for this report, I wish to capture a case might fall into one of the columns (only one column such as DECLEAREDDATE OR...

    Josephptran15 pointsBadges:
  • SQL Stored Procedure

    Is there a way to call a child stored procedure form a parent sp but then immediately stop the parent?

    Bbdezine235 pointsBadges:
  • Store Procedure Codes Please help

    I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE,...

    Josephptran15 pointsBadges:
  • pass variable from Foreach loop to stored Procedure parameters

    in control flow I run "Execute SQL Task" to retrive array variables like State Code ('AR', 'WI', .. et). Then I run ForeEach Loop Container and pass global variable gv_StateCode into Data Flow, where I run stored proc with one parameter in "OLE DB Source" (like exec sp_StProcname ?) and i assign...

    IG194410 pointsBadges:
  • Permissions for writing stored procedures in MySQL

    Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I...

    Ktrramu5 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Is there a way to retrieve datatypes from stored procedures?

    I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Is there a way to...

    TlogP15 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Updating values in a table in a SQL database

    I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and if the count is null, I am...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using SQL CLI APIs to call an sql stored procedure on an AS400

    I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

    I5DB2DBA5 pointsBadges:
  • Difference between Sp_msforeachdb and sp_msforeachtable

    In MS SQL Server what is the difference between Sp_msforeachdb and sp_msforeachtable

    Jaideep Khanduja9,040 pointsBadges:
  • Slowdown of the SAN due to overusage of temporary tables

    We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

    SQL Server Ask the Experts2,585 pointsBadges:
  • sp_OACreate is missing

    Hi I'm trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don't know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually?...

    Kowalski5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following