I´m trying to execute stored procedure but I get an issue of an existing temporal table, but I just create one time and use into another part of code SELECT … INTO #tmpUnidadesPresupuestadas FROM …
Tag: stored-procedures
Covert a duplicate Row value into column using pivot table
Here is my stored procedure query to fetch data in first table. I have following Data in a temp table. I want Name 1, Name 2, Name 3 as column and their value against the respective item.Data in table is dynamic.There can be any number of Items and any number of Name. For every Name and Item their is a
Error converting data type varchar to int error in stored procedure
My stored procedure is SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Customer_Registrations] @type varchar(50) = null, @Customer_ID int = null, @Customer_Name …
SQL: SAP Hana if parameter is null, ignore where
I’m passing 3 parameters into my Hana Stored Procedure to use as WHERE clauses, and if the parameter is null, I want the procedure to behave as though that condition doesn’t exist. example: if one of the input parameters is deviceType. if deviceType is null, query should simply be I know I can ach…
SQL Stored Procedure Select Multiple Rows and Insert Into Another Table
I know this question may sound like a duplicate, but I searched and couldn’t find a good answer yet. I have a stored procedure (started) that looks like this: The problem is the Select returns multiple rows and all of them need to be inserted into the other table. I’m really just not sure where to…
EF6 Stored Procedure does not accept parameters
I am using EF6 and I need to execute stored procedure. It takes two parameters: mIIN varchar(12), which is input string mXMLOutput varchar(max), which is the result of execution It works fine when I call it from Management Studio. However, when I use the following code: which results in the error Procedure or…
the name is not a valid identifier. error in dynamic stored procudure
my stored procudure is : when execute show this error: The name ‘SELECT IDproduct,name_product,first_price,final_price,max_registered_price, date_record_shamsi,final_date_view_shamsi, count_views,image_1,collection_1 from Table_asbabbazi where active=0 AND (name_product LIKE %@name_product%) AND (collec…
Oracle Error PLS-00323: subprogram or cursor is declared in a package specification and must be defined in the package body
Can someone help me put my pl/sql procedure in a package? I’ve tried and I’m struggling with it: This is what I have, for my package specification: This is my package body where im running into the problems: if anyone could help me fix the errors i’d appreciate it: Answer Your header and bod…
Calling Stored Procedure while passing parameters from Access Module in VBA
I am working in Access 2010 with a Microsoft SQL Server 2008 backend. I have a stored procedure that inserts new values(supplied by the parameters) into a table. The values assigned to the parameters are obtained from files stored in a folder. The Windows File System is used to scan a particular folder to mak…
Getting records with month by month, year by year and day by day from SQL Server
I’m looking for a fast and easy SQL Query to get records year by year, month by month and day by day. My database example: ID – DATE – CatID – VALUE 1 – 2013-08-06 – 32 – 243 2 – 2013-…