In this video, we learn how to complex Stored Procedure to print loan statement.
Пікірлер: 41
@bhakthasingh8198 Жыл бұрын
You are an excellent Teacher? Great job!!
@mmohan6925 ай бұрын
Thank you very much sir .I got better clarity after i watched your videos
@BhaskarJogiSQLandBI2 ай бұрын
Thank you
@kesavanmechanical Жыл бұрын
Thankyou sir ! Taking real time example and explaining very tough concepts easily.
@BhaskarJogiSQLandBI Жыл бұрын
You are most welcome
@lalithkumar0012 жыл бұрын
This video was very well explained. Crisp and clear.
@mercydabbs33302 жыл бұрын
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.
@BhaskarJogiSQLandBI Жыл бұрын
Thanks lot
@tiksG6 жыл бұрын
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.
@supermasters91562 жыл бұрын
Thank you very much for this video. You explained it so well. Keep up your good work.
@riteshpatel1836Ай бұрын
Great Explaination
@BhaskarJogiSQLandBIАй бұрын
Thank you
@kunnudev72504 жыл бұрын
Great job please continue awesome videos
@priyankatripathi5626 жыл бұрын
awsome..Thanks for this
@prathameshshinde72818 жыл бұрын
sir please continue your good work, it's tremendously helpful. Thank you so much🙂
@BhaskarJogiSQLandBI8 жыл бұрын
You are welcome
@narayanagottipati59805 жыл бұрын
@@BhaskarJogiSQLandBI sir please make a video on performance tuning...thanks
@RamRam-ce2yk2 жыл бұрын
Thanks so much Sir.. ❤️🙏 Super explanation it's very easy to understand u r words. Thanks so much ❤️
@venkychepuri5876 жыл бұрын
Thank you So Much SIr
@iamwithyou61654 жыл бұрын
Excellent video 👌
@biswanathdas26888 жыл бұрын
its really helpful ..
@sunpreetsingh51435 жыл бұрын
very nicely explained ...
@harikrishnareddy27003 жыл бұрын
Great explanation, thanks a lot
@BhaskarJogiSQLandBI3 жыл бұрын
You are welcome!
@Rajeeb7017 жыл бұрын
good helpful
@hemantkilanje88653 жыл бұрын
Thanks🌹😊
@7to7media5 жыл бұрын
Please make video on SQL performance tuning
@ramprashathmba62257 жыл бұрын
Upload complete tutorial..so, that we can understood sir..Please
@naveenKumar-iq9dr2 жыл бұрын
If we want give dynamically values how w e do
@maestroroshi16275 жыл бұрын
nice
@just4fun4107 жыл бұрын
Hello sir, Your tutorials are really very good, but the thing is if we take 1000000, 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
@yamanthakur7352 Жыл бұрын
Simple maths : (100000*14*2)/100 =28000, Now plus principal amount : 28000+100000=128000 and divide by 24(2years) =128000/24=5,333.33
@priyankashinde29165 жыл бұрын
Can you please share video on optimisation
@aravindyadav99610 ай бұрын
HI SIR I HAVE TRIED THE CODE BUT IM GETTING ERROR CAN U PLS HELP ME
@BhaskarJogiSQLandBI10 ай бұрын
Send me code to bhaskarjogi@gmail.com
@Anas_ILoveMyIndia4 жыл бұрын
Hi Sir, Please share iBank DB for my practice
@BhaskarJogiSQLandBI4 жыл бұрын
send me a mail to bhaskarjogi@gmail.com
@Anas_ILoveMyIndia4 жыл бұрын
@@BhaskarJogiSQLandBI okay sir, Thank you..!!
@Suraaps14154 жыл бұрын
find the procedure script below, modify the proc accordingly and run . ALTER PROCEDURE [dbo].[Proc_EMI_Amount] ( @LOANAMOUNT MONEY=100000, @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 SET @AMOUNT= (@LOANAMOUNT*@INTEREST* @TENURE)/100 --CALCULATE TOATAL AMOUNT --TOTAL AMOUNT WOULD BE LOANAMOUNT + INTEREST DECLARE @TOTAMOUNT MONEY SET @TOTAMOUNT=@LOANAMOUNT+@INTEREST --CALCULATE THE EMI AMOUNT -- @TOTAL AMOUNT / NO OF MONTHS DECLARE @EMI MONEY SET @EMI= @TOTAMOUNT/(@TENURE*12) --USE WHILE LOOP AND DISPLAY THE OUTPUT DECLARE @MONTH INT SET @MONTH=1 WHILE(@MONTH