I’m trying to copy an existing ship, with all of its contents of its child tables (for lack of a better term) and their relations. So far I’ve got most of the copying down except for the ship’s tables that have a many to many relation. An example of my current situation is as follows: I have…
Tag: stored-procedures
PostgreSQL- If data in table, delete for stored procedure
I have this procedure, which I call with CALL pr_calc_quarter(2,2022), that insert data into a table erp.tb_quarter from a query. I need to add code to check that if there is already data in the table, to delete it before inserting new values. I was thinking of inserting the code at the beggining or before th…
Using Variables Passing Into MSSQL Stored Proc as part of queries
I want to use the value from variables that is passed into the stored proc. Is that allow? For example, I want to pass CID=5,SID=4 Into an Update Stored Proc and it looks like this: In which is like “DELETE FROM [User54]” But I want to dynamically done given the parameter Can it be done and how is…
How to not lose unicode characters in Stored Procedure parameter
Problem Statement: We are having a legacy application with backend as SQL Server. Till now, we did not face any issues in passing non-unicode values. Now, we are getting unicode characters from user interface. The unicode character is getting passed as given below, in UI. These data are being inserted into ta…
Input/output parameters are not visible when executing procedure in SQL navigator
When I execute my stored procedure in SQL Navigator 7.2.0, the input parameters are not shown. There is nothing wrong with the stored procedure. Is there any configuration to add up? An answer would be really helpful. Below is how it shows when I execute the stored procedure, where I can’t add any param…
Trying to create procedure in snowflake and getting error while passing value to another procedure
Below procedure to get the value from the metadata table and pass its value into another procedure. Give the error message: Execution error in store procedure GET_RESULTS: SQL compilation error: error line 1 at position 16 invalid indetifier ‘STBL1’ At Statement.execute, line 18 position 26 Answer…
Accept parameters in the combination of columns for retrieving many records
Table1 has 4 columns = Col1 , Col2 , Col3 , Col4 Col1 is id(integer) column = 156 , 159 , 175 Col2 is varchar column = CAA , DFE , EME Col3 is varchar column = 12345 , 23465 , 43122 Col4 is varchar column = 2 , 3 , 6 I am creating a stored procedure which accepts
How to return the count of a table created and dropped within a SQL stored procedure in Snowflake?
I am trying to use a variable to store the count in a temporary table created within a stored procedure in Snowflake so that I can include the value in the return statement. When I try to do a select count(*) from the table I get SQL compilation error: Object ‘CDP_SMS.DOMAIN_CANONICAL.TEMP_DELTA_MANUFAC…
Create a JSON object to be sent as parameter to Stored Procedure
I have a stored proc say sp_proc_1 which takes in a few parameters say @val1, @val2, and @val3. I would like to make a JSON object using the values @val1 and @val2 so that I can pass that JSON object as one of the parameters to a second stored procedure sp_proc2 which I will be invoking from sp_proc1. Please …
Need SQLQuery with Stored procedure with below example
I have the following MySQL-table the average must be using stored procedure, not normal query. I have normal SQL Query I want that to look like this, with a MySQL query: Answer If the Id’s on your table are unique, you can do it like this (you were pretty close… just the case when was missed in yo…