Design stored procedure with clause

I have a rather large stored procedure to develop. The procedure is going to be used in a large crystal report. I was wondering if you can design a stored procedure using a with clause. I used CTE on SQL Server but that doesn't seem to be an option.

jvichich5 pointsBadges:

How to make new field available in Crystal Reports

Hello, Before I ask my question, I just want to let you know that this is for Crystal Reports. I recently added a new field to my stored procedure. How do I get that available in CR? I don't want to reset the data source. Thanks!

ITKE1,067,645 pointsBadges:

Call stored procedures asynchronously on DB2 database

I'm working on a DB2 database - would I be able to call my stored procedure from another procedure asynchronously? Thanks so much.

ITKE1,067,645 pointsBadges:

Sending an email alert to addresses in the database and getting a return email as notification

Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

ADagoseh25 pointsBadges:

Stored procedure to transfer data in Oracle SQL Developer

How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

dreamersai5 pointsBadges:

Error message when creating a stored procedure: SPxxx is created but cannot be saved or restored

I created a stored procedure on AS/400, the message in return was 'SPxxx is created but cannot be saved or restored '. I am able to view the created stored procedure in the Library but when I call the procedure the error message was 'SPxx was not found with specified parameters". How to resolve...

bharathtata30 pointsBadges:

What are the basic parameters needed to assist an automation tool?

My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

VijayVardhan5 pointsBadges:

Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

ITKE1,067,645 pointsBadges:

Search text in SQL Server stored procedure

For SQL Server, I'm trying to search a text from all of my database stored procedures. Here's the code I'm using: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%[ABD]%'; But I'm not getting...

ITKE1,067,645 pointsBadges:

Setup query execution plan for stored procedure in SQL Server

I'm currently using SQL Server and I need to setup a query execution plan for my stored procedure. How can I go about this? Can I use SSMS? Thanks!

ITKE1,067,645 pointsBadges:

How to send stored procedure parameter to Trigger?

I am sending a parameter from ASP.NET web API to a stored procedure. Now how do I send that SP parameter to Trigger?

AnshuRishiPratapReddy5 pointsBadges:

SQL Server: Create table to hold result of stored procedure

With SQL Server, I usually write a query like this: create table #table_name ( column1 int, column2 varchar(200) ... ) insert into #table_name execute some_stored_procedure; But here's my issue: When creating a table to have the right syntax as the result of the stored procedure is too long of a...

ITKE1,067,645 pointsBadges:

SQL Server: Query is filling up TEMPDB database

I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

ITKE1,067,645 pointsBadges:

SQL Server 2012 – Profile stored procedures

I'm currently using SQL Server 2012 and I'm trying to figure out if I can profile stored procedures. I need to capture each SQL Statement in my stored procedures (basically how long it takes to run). Thanks so much.

ITKE1,067,645 pointsBadges:

Copy SQL stored procedure from local to live database

Hello, I want to copy multiple procedures from a local database to a live database?

vikasbhatt25 pointsBadges:

SQL Server: Parameterize IN clause

Is there a way to parameterize an SQL query that contains an IN clause with a variable number of arguments? Something along the lines of this: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc I don't want to use a stored procedure/XML so what's the best...

ITKE1,067,645 pointsBadges:

SQL stored procedure is taking too much time to execute

One store procedure is working fine at one location. But the same store procedure is taking too much time to execute in different location on same network. What would be reason for this and how to reduce response time?

mukeshkumar1230 pointsBadges:

Call a stored procedure on a SQL Server from my RPGLE source using JDBCR4 service program.

Something is going wrong while setting up the connection environment (ZBCCNNPF). Can someone explain me which parameters have to be set in which way to make this process work? Kind regards, Ton Konings.

TonKonings196215 pointsBadges:

Calling COBOL program from native DB2 stored procedure

Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

Tanmay2115 pointsBadges:

SQL Server 2014: Automatic update trigger if the record is duplicate

I am using SQL 2014 and want to insert and update a lot of records within a Stored Procedure, and then have a trigger to rollback the record if it already existed and then update just after the rollback. Is there a better way of doing this?

edwinjhoffer3,725 pointsBadges: