Better Sql ?? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Better Sql ??

Author

Topic

nvakeel
Yak Posting Veteran

52 Posts

Posted - 2008-02-12 : 10:48:22

SET @WS_GROSS_CHECK_2 = @WS_GROSS_CHECK_2 + @WS_ADDIT_WK

IF(@WS_GROSS_CHECK_2 < @GROSS_AMT_CK )
BEGIN
SET @ADD_PEN_CK = @WS_ADDIT_WK
SET @WS_ADDIT_WK = 0
END
ELSE
BEGIN

SET @WS_WK_A = @WS_GROSS_CHECK_2 - @GROSS_AMT_CK
SET @WS_WK_A = @WS_ADDIT_WK - @WS_WK_A
SET @ADD_PEN_CK = @WS_WK_A
/* VARIABLES DECARE IN TABE*/
SET @WS_ADDIT_WK = @WS_ADDIT_WK - @WS_WK_A
---- 0135-RETIRRE
EXEC sp_PRNJ_B34181_0135_RETIREE_MULTI_CHK @job_inst_id ,@SSN,@RCD_CD,@GROSS_AMT_CK,@WS_GROSS_CHECK_WK
--- CONTROL DOES NOT COME BACK HERE ASK ABOUT IT ----
GOTO PROCESS_081M_0130_EXIT
END

----------------------------------------------------

SET @WS_ADDIT_WK = Case When (@WS_GROSS_CHECK_2 < @GROSS_AMT_CK )
Then 0
Else @WS_ADDIT_WK
End

SET @WS_WK_A = Case When (@WS_GROSS_CHECK_2 < @GROSS_AMT_CK )
Then @WS_WK_A
Else (@WS_ADDIT_WK - (@WS_GROSS_CHECK_2 - @GROSS_AMT_CK))
End
SET @ADD_PEN_CK = Case When (@WS_GROSS_CHECK_2 < @GROSS_AMT_CK )
Then @WS_ADDIT_WK
Else (@WS_ADDIT_WK - @WS_WK_A )
End
If (@WS_GROSS_CHECK_2 < @GROSS_AMT_CK )
Begin
EXEC sp_PRNJ_B34181_0135_RETIREE_MULTI_CHK @job_inst_id ,@SSN,@RCD_CD,@GROSS_AMT_CK,@WS_GROSS_CHECK_WK
--- CONTROL DOES NOT COME BACK HERE ASK ABOUT IT ----
GOTO PROCESS_081M_0130_EXIT
END

Which code is better while running with 1 lakh records.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-12 : 10:49:27

For non-Indian people, 1 Lakh is 100000 records.

E 12°55'05.25"
N 56°04'39.16"