I don’t know why, but with print_r I do get the results! print_r($row); Displays: Array ( [open_uitdagingen] => 3 ) So i did get the result, but why var_dump($res->fetch_assoc()); gives an empty result? I still don’t know, but i can go on now an that counts:) solved Stored procedure, no values returned? [closed]
The problem is not at the procedure it is at the calling. When you call the stored procedure, you need to declare and pass in the required parameter declare @NAME VARCHAR(50), @CITY VARCHAR(200), @MOBILE NUMERIC(20) execute GETDETAIL @AGE = 21, @NAME = @NAME OUTPUT, @CITY = @CITY OUTPUT, @MOBILE = @MOBILE OUTPUT SELECT @NAME, @CITY, … Read more
SO is not a website when you throw everything here and expected people finish the job for you. Anyway, to give you some hint, I give you a straight suggestion: Select CostGroupId From CostGroups Where CostGroupType = 1 –> Stored these in A collection, like an array: var costGroupsIdArr = ctx.CostGroup.Where(x=>x.CostGroupType == 1).Select(x.CostGroupId).toArray(); Then from … Read more
Try this: DECLARE @SUM VARCHAR(50)=’33.90′; SELECT CAST(CAST(LEFT(@SUM,CHARINDEX(‘.’,@SUM,0)-1) AS INT)+ CAST(SUBSTRING(@SUM,CHARINDEX(‘.’,@SUM,0)+1,LEN(@SUM)) AS INT)/60 AS VARCHAR(10))+’.’+ CAST(CAST(SUBSTRING(@SUM,CHARINDEX(‘.’,@SUM,0)+1,LEN(@SUM)) AS INT)%60 AS VARCHAR(10)) result: 34.30 1 solved How to convert the Varchar of sum to time using sql server 2008 [closed]
As David said you are almost there but just need minor changes. I suppose @Pid is a parameter,if so, it is missing from the Stored Procedure defintion. The (and specialistId=@Pid and iscompleted =1) form the Where clause (Filter expression). So the procedure goes like this ` CREATE PROCEDURE PROCD1 (@PID INT ) AS BEGIN SELECT … Read more
Well, the error you are getting doesn’t really have anything to do with stored procedures, but I can answer the question of “how to solve this?” in the context of the exception you are getting. First, I hope you are not using “something” as the actual connection string to your sql server. You should be … Read more
Given an input XML, you can use this simple XQuery statement to “shred” the XML into relational rows and columns – just do a simple INSERT INTO ….. and you’re done. No messy cursor nor OPENXML stuff needed… DECLARE @input XML = ‘<Salaray> <TransactionSalary EmpSL=”2″ Basic=”9860″ Grad_pay=”4100.00″ DA=”6282.00″ HRA=”2094″ MA=”300.00″ Ptax=”150.00″ pf=”2000″ Itax=”0.00″ LIC=”0.00″ Month_Of=”14/Dec/2012″ … Read more
Use it as Declare @num int Set @num =1 SELECT * FROM USERLOGIN WHERE USERNAME=@username AND PWD=@PWD AND level = @num if you are using SQL server below 2008 or like Declare @num int=1 SELECT * FROM USERLOGIN WHERE USERNAME=@username AND PWD=@PWD AND level = @num for SQL Server 2008 and above 0 solved Getting … Read more
As I wrote in the comment the answer of your first question is: If I understand your PRC well, in case of @IP = ” it should returns a wieder set of members. I think it is possible that the Username, Email or Country is longer in the member table then the @Temp table’s definition. … Read more
You should either use this method: SqlCommand cmd = new SqlCommand(“dbo.workScheduleDataGrid”, sqlcon); or this method SqlCommand cmd = sqlcon.CreateCommand(); to create the command, but not both (the second assignment in your code overwrites the first one). With the second options, you need to specify the command to execute separarely: cmd.CommandText = “dbo.workScheduleDataGrid”; Also, do not … Read more
In you sql code add this line CASE WHEN Approach = 0 THEN NULL END AS Approach so in your stored procedure when Approach will come as 0 then it will be replaced with NULL solved How to modify stored procedure to give null instead of 0
Try passing null value for unused parameters and inside the stored procedure put a check for nulls to switch tables. CREATE PROCEDURE [dbo].[proc_search_patient_ByID] ( @PatID_pk int , @Cntid smallint, @FamID int ) AS SET NOCOUNT ON IF @Cntid IS NULL BEGIN –Use select stmt of a table END ELSE –Use select stmt of another table … Read more
Just make it one: create function ops() returns table (region varchar, man integer, woman integer, test integer) as $$ Select region,man, woman, Case When woman > man then woman – man When woman < man then man – woman ELSE 0 END AS test From people; $$ language sql; 0 solved Postgresql switch query to … Read more
You need to use dynamic SQL and generate the sentence. Check out this link. Pay special attention to section Using sp_executesql. Something like that is almost exactly what you need. 2 solved if between 10 variable [closed]
As Ranzo notes several of the other answers are are also plausible. So, why is E the correct answer? Because the question asks for the most appropriate location for the code. Let’s break it down. The logic needs to be called from several places. It is therefore necessary to define it as its own function … Read more