SQL Server - Create Complex Stored Procedures

In this video, we learn how to complex Stored Procedure to print loan statement.

[kesavanmechanical]

Thankyou sir ! Taking real time example and explaining very tough concepts easily.

[mmohan]

Thank you very much sir .I got better clarity after i watched your videos

[bhakthasingh]

You are an excellent Teacher? Great job!!

[mercydabbs]

I know this was done a long time ago, but you are the best! Thank you for touching all important scenarios with real example. I hope I can see more of your videos.

[prathameshshinde]

sir please continue your good work, it's tremendously helpful. Thank you so much🙂

[tiksG]

It's really helpful sirji
I understood completely without having enough knowledge of SQL.
I request you sirji please upload complete series of SQL, so it helps for lots of students.

Thanks for doing such nice work for students as well as for professionals.

Thanks again.

[lalithkumar]

This video was very well explained. Crisp and clear.

[supermasters]

Thank you very much for this video. You explained it so well. Keep up your good work.

[kunnudev]

Great job please continue awesome videos

[RamRam-ceyk]

Thanks so much Sir.. ❤️🙏
Super explanation it's very easy to understand u r words.

Thanks so much ❤️

[tomedia]

Please make video on SQL performance tuning

[justfun]

Hello sir,

Your tutorials are really very good, but the thing is if we take for 2 year with rate of interest 14%, then it should come monthly emi is 48, 013, but you have shown 53333.33. How is it possible, can u clarify that.

Thanks
Vamsi

[ramprashathmba]

Upload complete tutorial..so, that we can understood sir..Please

[priyankashinde]

Can you please share video on optimisation

[naveenKumar-iqdr]

If we want give dynamically values how w e do

[Suraaps]

find the procedure script below, modify the proc accordingly and run .



ALTER PROCEDURE [dbo].[Proc_EMI_Amount]
(
@LOANAMOUNT
@INTEREST INT =14,
@TENURE INT =2
)
AS
BEGIN

-- Declare a loan variable for loan date--

declare @LoanDT datetime
set @LoanDT=GETDATE();

--FIND THE INTEREST AMOUNT BY USING LOAN AMOUNT FORMULA --
--formula =PNR/100

DECLARE @AMOUNT MONEY


--CALCULATE TOATAL AMOUNT
--TOTAL AMOUNT WOULD BE LOANAMOUNT + INTEREST

DECLARE @TOTAMOUNT MONEY


--CALCULATE THE EMI AMOUNT
-- @TOTAL AMOUNT / NO OF MONTHS

DECLARE @EMI MONEY


--USE WHILE LOOP AND DISPLAY THE OUTPUT



DECLARE @MONTH INT
SET @MONTH=1
BEGIN
END

END


/*

IN THE ABOVE PROCEDURES WE USED

--WHILE LOOP
--DATEADD FUNCTION
--PRINT FUNCTION

LOOP STRUCTURE
DECLARE @Counter INT
SET @Counter=1
WHILE ( @Counter <= 10)
BEGIN
SET @Counter = @Counter + 1
END

SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;


EXEC [Proc_EMI_Amount]

*/

[aravindyadav]

HI SIR I HAVE TRIED THE CODE BUT IM GETTING ERROR CAN U PLS HELP ME

[Anas_ILoveMyIndia]

Hi Sir, Please share iBank DB for my practice