ALTER PROCEDURE [dbo].[uspGetSickVacCompESSTPreviousPayroll]

@Employee_ID int = NULL,

@PayrollDetail_ID int = NULL

AS

BEGIN

IF OBJECT_ID('tempdb.dbo.#temptbl', 'U') IS NOT NULL

DROP TABLE #temptbl

CREATE TABLE #temptbl (tmppayrollID int)

IF OBJECT_ID('tempdb.dbo.#tmptblPrevpayrollDtid', 'U') IS NOT NULL

DROP TABLE #tmptblPrevpayrollDtid

SELECT

Payroll_Detail_ID as value_prev

into #tmptblPrevpayrollDtid

FROM...

I resolved the problem on my own, but thank you all for jumping in to help me.

I want to post this code so that if anyone else has similar problem,...

I resolved the problem on my own, but thank you all very much who jumped in to help me.

I am posting this code to help others if anyone is looking...

The above result set is always giving me the last but one row, whatever the row I select from my application, but I need the last but one row from...

By the way drop table if exists is throwing error while compiling

Thank you Very much for all the help, greatly appreciate your timely help, I will try to code and will you know, I was busy working on other module, hence...

I am totally new to programming and SQL, please someone help me with the logic to extract the resulting columns into a select query so that I can pass it...

Hi Jmetape, This is the same case where I am getting more than one row and I don't know how to extract the row (alone) from the stored procedure

 

December 14, 2023 at 6:43 pm

#4346058

I tried with Lag, but it returns more than one row from which I don't know how extract the data of the previous row and use it.

 

Here is what I...

Yes, I just need the previous one alone and not all the previous records. When I hit the row in the front end with payroll Detail ID 3 of employee...

Thank you for the quick response.

I am not sure how to use the results to get the row what I need, here is my result set. When I hit the...