15,796,299 members

# Comments by Hemil Gandhi (Top 49 by date)

Hemil Gandhi 21-Aug-22 1:08am View
Actual query is working , some how after pasting doble quote is added by system.
Hemil Gandhi 19-Aug-22 8:50am View
I have tried the following , any other / faster way to do it??
create table #alm
(
acno varchar(10)
,emi numeric(10)
,balance numeric(10)
,cdate date
,ldate date
,dy numeric(10)
,"2D-7D" numeric(10)
,"8D-14D" numeric(10)
,"15D-28D" numeric(10)
,"29D-89D" numeric(10)
,"90D-6M" numeric(10)
,"6M-12M" numeric(10)
,"12M-36M" numeric(10)
,"36M-60M" numeric(10)
,"Abv60M" numeric(10))

insert into #alm(acno,emi,balance,cdate,ldate) values (1,5512,488568.00,GETDATE(),'2022-08-04')

update #alm set dy =
case when (balance/emi)<datediff(month, getdate(),="" '2025-08-04')="" then="" (balance="" emi)="" else="" datediff(day,="" '2025-10-30')="" end

update="" #alm="" set="" "15d-28d"="balance,"29D-89D"=0,"90D-6M"=0,"6M-12M"=0,"12M-36M"=0,"36M-60M"=0,"Abv60M"=0" where="" dy<="28
update" dy="">=29 and dy<=89
update #alm set "15D-28D"=emi,"29D-89D"=emi*2,"90D-6M"=balance-(emi*3),"6M-12M"=0,"12M-36M"=0,"36M-60M"=0,"Abv60M"=0 where dy>=90 and dy<=180
update #alm set "15D-28D"=emi,"29D-89D"=emi*2,"90D-6M"=emi*3,"6M-12M"=balance-(emi*6),"12M-36M"=0,"36M-60M"=0,"Abv60M"=0 where dy>=181 and dy<=365
update #alm set "15D-28D"=emi,"29D-89D"=emi*2,"90D-6M"=emi*3,"6M-12M"=emi*6,"12M-36M"=balance-(emi*12),"36M-60M"=0,"Abv60M"=0 where dy>=366 and dy<=1095
update #alm set "15D-28D"=emi,"29D-89D"=emi*2,"90D-6M"=emi*3,"6M-12M"=emi*6,"12M-36M"=emi*24,"36M-60M"=balance-(emi*36),"Abv60M"=0 where dy>=1096 and dy<=1825
update #alm set "15D-28D"=emi,"29D-89D"=emi*2,"90D-6M"=emi*3,"6M-12M"=emi*6,"12M-36M"=emi*24,"36M-60M"=emi*24,"Abv60M"=balance-(emi*60) where dy>=1826
Hemil Gandhi 25-Apr-21 7:38am View
Incorrect Syntax near "CASE"
Incorrect Syntax near "END"
Hemil Gandhi 21-Apr-21 0:53am View
Sorry for the inconvenience, Scenario is there is html with variables like \$name,14. Whenever I run program system bing customer name with variable \$name & displays report. Same way there are variable \$bal1 & \$bal2 . I want sum of this two.
Hemil Gandhi 21-Apr-21 0:50am View
I dont have source code,solution is deployed at my end & I can do changes only in html file.