Stored Procedures

Calling a stored procedure in a SELECT list on SQL Server 2000

I am using SQL Server 2000, and my question is: is there any way to call a stored procedure in a SELECT list?

Migrating stored procedures from SQL Server 2000 compatibility mode to a SQL Server 2005 database

I recently migrated some reports and stored procedures from a SQL Server 2005 database server in SQL Server 2000 compatibility mode to a SQL Server 2005 database. Afterwards, we have not been able to get the stored procedures to run to completion. We have found two issues: one is collation...

Copying a SQL Server stored procedure with a query

I want to copy a SQL Server 2005 stored procedure by using a query, much like the way a table is copied with one. Does a query exist that could perform this task for me?

Executing a Stored procedure using Excel Macro

I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

Stored procedures in SSRS

Can we call the stored procedure in SSRS when creating reports.I am new to sql server plaese help me in this question

Call Stored Procedure Multiple times

I want to use a SQL script that takes values from one table and then calls a stored procedure multiple times for each of those values. Each time, I am passing in those values as a parameter for each stored procedure call. How can I do that?

Using Oracle 10g Stored proc in SSRS 2005

I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run...

Execution time is varying with query analyzer and visual studio 2005

when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue

MySQL Stored Procedures with Parameters in Crystal Reports 9???

Hi, am using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the...

Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?

I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?

Running Procedures within the PL/SQL program

WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

How to pass Parameter of stored procedure Crystal report

How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure

Scheduled job for Oracle 9 returning ORA-01858

We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...

How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t...

How can I collect database/server information across multiple MSSQL versions.

I would like to collect database info(backups, databases, logins, etc) as well as server information ( MSSQL version, patch level, etc). I would like to use one server to collect information from all of my servers. I have MSSQL 7, 2000, & 2005 on Windows servers 2000 & 2003. I am also new to...

How can I take a backup of a SQL Server stored procedure only?

How can I take a backup of a SQL Server stored procedure only?

Having problems converting SQL Server queries to stored procedures

I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query,...

How do I move all stored procedures to a new SQL server?

I recently moved a database from SQL Server 2000 to a new server running SQL Server 2005. Is it possible to move all of the stored procedures to the new server?

Stored Procedure Problem

Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL =...

SQL Stored Procedures

I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL...