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 way I...
Answer Question
| May 12 2008 11:10 AM GMT
| asked by
Les za
Crystal Reports 9, MySQL, Stored procedures
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?
View Answer
| Apr 28 2008 3:49 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server stored procedures, Stored procedures
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?!
View Answer
| Apr 28 2008 10:53 AM GMT
| asked by
Nimsalwayz
PL/SQL, SQL Server stored procedures, EXEC
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
Answer Question
| Apr 16 2008 12:42 AM GMT
| asked by
N7
Crystal Reports, Stored procedures, VB
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...
View Answer
| Apr 10 2008 3:05 PM GMT
| asked by
OracleATE
ORA-01858, Oracle Scheduler, Stored procedures
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 know...
View Answer
| Apr 8 2008 11:30 PM GMT
| asked by
SQL Server Ask the Experts
SSIS, SQL Server integration/interoperability, Stored procedures
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 MSSQL &...
View Answer
| Apr 7 2008 6:09 PM GMT
| asked by
AngieJo
SQL Server, Scripting, Stored procedures
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?
View Answer
| Apr 3 2008 7:55 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server backup, Stored procedures
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, which...
View Answer
| Mar 21 2008 8:38 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Stored procedures, SQL queries
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?
View Answer
| Mar 21 2008 7:01 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL Server 2005, Stored procedures
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 = “Select *...
View Answer
| Mar 20 2008 3:34 PM GMT
| asked by
Anilak singh
Stored procedures, Stored Procedure variables, 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...
Answer Question
| Mar 19 2008 9:31 AM GMT
| asked by
Jglyons
SQL, Stored procedures
SQL Server - I would like a stored procedure that will take the name of a table as input.
I would like a stored procedure that will take the name of a table as input.What the procedure would do is drop all indexes on that table except any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another stored procedure that takes a table name as...
View Answer
| Mar 18 2008 3:18 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance, SQL Server, Stored procedures
How can I initialize arrays in stored procedures?
How can I initialize arrays in stored procedures?
View Answer
| Mar 16 2008 10:20 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Stored procedures
Passing a database name as a stored procedure parameter
I would like to be able to pass the name of a database as a parameter to a stored procedure. This db would be used for certain queries and may be different from the db where the stored procedure runs. Is it possible to specify a database name from within the T-SQL of the stored procedure? If so,...
View Answer
| Mar 11 2008 10:13 PM GMT
| asked by
SQL Server Ask the Experts
Stored procedures, T-SQL
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
View Answer
| Mar 4 2008 11:39 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Stored procedures
Equivolent SQL Server function for Access DoCmd.TransferText
I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?
View Answer
| Mar 3 2008 4:36 PM GMT
| asked by
Paul48
Microsoft Access, Stored procedures, SQL Server
Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another strored procedure that takes a table name as...
View Answer
| Feb 28 2008 4:04 PM GMT
| asked by
Dangagne
Indexes, DROP, Restore
Msg 102, level 15, State 1, Line 102
I get this with an 'Incorrect syntax' messasge when I run a stored procedure. if I run the 'offending' code in isolation it works fine. If I tidy the code (e.g. remove line feeds etc), the error 'moves' to a different location. HELP!
View Answer
| Feb 27 2008 12:55 AM GMT
| asked by
TonyDyer
SQL Server, Stored procedures, SQL Server errors
Performance Tracking of Stored Procedures
we have a current system where a COBOL stored procedure is called by a .NET application. This COBOL SP then calls multiple COBOL subprograms which perform calculations and update files and then eventually return a value to the .NET app. We have a limitation in tracking the performance of each...
View Answer
| Feb 26 2008 7:07 PM GMT
| asked by
Pcrum73
COBOL, COBOL stored procedure, Performance/Tuning
