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.
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.
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
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
Thank you very much sir .I got better clarity after i watched your videos
Thank you
Thankyou sir ! Taking real time example and explaining very tough concepts easily.
You are most welcome
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.
You are an excellent Teacher? Great job!!
This video was very well explained. Crisp and clear.
Great job please continue awesome videos
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.
Thanks lot
Great Explaination
Thank you
Thank you very much for this video. You explained it so well. Keep up your good work.
sir please continue your good work, it's tremendously helpful. Thank you so much🙂
You are welcome
@@BhaskarJogiSQLandBI sir please make a video on performance tuning...thanks
Thanks so much Sir.. ❤️🙏
Super explanation it's very easy to understand u r words.
Thanks so much ❤️
Excellent video 👌
Great explanation, thanks a lot
You are welcome!
very nicely explained ...
awsome..Thanks for this
good helpful
its really helpful ..
Thanks🌹😊
Please make video on SQL performance tuning
Thank you So Much SIr
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
Simple maths : (100000*14*2)/100 =28000, Now plus principal amount : 28000+100000=128000 and divide by 24(2years) =128000/24=5,333.33
Upload complete tutorial..so, that we can understood sir..Please
nice
If we want give dynamically values how w e do
Can you please share video on optimisation
HI SIR I HAVE TRIED THE CODE BUT IM GETTING ERROR CAN U PLS HELP ME
Send me code to bhaskarjogi@gmail.com
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
Hi Sir, Please share iBank DB for my practice
send me a mail to bhaskarjogi@gmail.com
@@BhaskarJogiSQLandBI okay sir, Thank you..!!