Comments by Hemil Gandhi

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.

Hemil Gandhi 12-Jan-21 12:06pm View

Dear Sir, Thanks for all your effort. Actually I have pre written code in which developer has encrypted sql query using some function & above lines are part of that function. I am getting error on those particular lines. So I have to solve this error to get what is written in query.

Hemil Gandhi 12-Jan-21 12:06pm View

Dear Sir, Thanks for all your effort. Actually I have pre written code in which developer has encrypted sql query using some function & above lines are part of that function. I am getting error on those particular lines. So I have to solve this error to get what is written in query.

Hemil Gandhi 4-Sep-20 9:52am View

Can you please help me with my problem described in below link, Please Help.

https://www.codeproject.com/Questions/5274724/Get-lower-value-through-mupltiple-joins

I am searching for the solution since very long.

Hemil Gandhi 3-Sep-20 13:27pm View

Thank you very much for such a wonderful solution

Hemil Gandhi 31-Aug-20 23:37pm View

This query solved my problem.

Hemil Gandhi 31-Aug-20 23:37pm View

noted sir

Hemil Gandhi 30-Aug-20 13:38pm View

hey hi, have you resolved your problem, I am looking for same kind of solution

Hemil Gandhi 30-Jul-20 13:20pm View

I can write all this queries individually but how to combined them all to get solution of my problem.

Hemil Gandhi 30-Jul-20 13:06pm View

Sir, i am not expert in sql queries.so i dont get your solution, can you please help me with query??

Hemil Gandhi 27-Jul-20 12:58pm View

I want name of lower custno/code in customer table.

Hemil Gandhi 27-Jul-20 12:57pm View

CustNo in customer table in named code

Hemil Gandhi 26-Jul-20 7:07am View

Thanks for the replying , I have updated the question. Hope I have covered all the missing details.

Hemil Gandhi 18-Jul-20 13:21pm View

Noted...!!! Finally I have made this query which skips the records of duplicate pan.

select c.name,c.pan,count(L.Acno) as Count,sum(L.ClearBal) as bal from LON20190629 as L inner join customer as C
on L.CustNo=c.Code inner joiN
(
SELECT pan, MIN(code) MinPoint
FROM customer
where len(pan)>6
GROUP BY PAN
) tbl1
ON tbl1.PAN = C.PAN
WHERE tbl1.MinPoint = C.code AND L.AcSts<>9 and l.ClearBal<0 group by c.PAN,c.Name order by bal desc

Hemil Gandhi 13-Jul-20 12:58pm View

I have two tables loan & customer, loan table is having customer number & balance where as customer table is having customer number,name & PAN.

Hemil Gandhi 13-Jul-20 10:43am View

select c.name,c.pan,count(L.Acno) as Count,sum(L.ClearBal) from LON20190629 as L inner join customer as C
on L.CustNo=c.Code inner joiN
(
SELECT pan, MIN(code) MinCustId
FROM customer
GROUP BY PAN
) tbl1
ON tbl1.PAN = C.PAN
WHERE tbl1.MinCustID = C.code AND l.AcSts<>9 group by c.PAN,c.Name

Hemil Gandhi 12-Jul-20 10:38am View

Deleted

My query has already one join, Now how to add name without Pan duplication. Name is in customer table

select customer.pan,count(LON20190629.Acno) as Count,sum(LON20190629.ClearBal) from LON20190629 inner join customer
on LON20190629.CustNo=customer.Code where AcSts<>9 and len(customer.pan)=10 group by PAN

Hemil Gandhi 12-Jul-20 10:36am View

I have build below mentioned query to get PAN wise data, Now I am clue less how to get name without duplication of PAN.

select customer.pan,count(LOAN.Acno) as Count,sum(LOAN.Bal) from LOAN inner join customer
on LOAN.CustNo=customer.Code where AcSts<>9 and len(customer.pan)=10 group by PAN

Hemil Gandhi 12-Jul-20 3:49am View

Question improved, please check now
sorry for the confusion

Hemil Gandhi 12-Jul-20 3:48am View

Question improved

Hemil Gandhi 12-Jul-20 1:57am View

You are correct I have mistakenly add one more a in "Aaaa". & I want name having lower customer I'd. Name are not similar that is my main issue while doing group by.
Hope I appropriately explained my self

Hemil Gandhi 8-Jul-20 7:01am View

In above table NPADt is date having three types of data 0,null or date i.e (20200807). How to show date in DD-MM-YYYY format??

Hemil Gandhi 8-Jul-20 7:01am View

In above table NPADt is date having three types of data 0,null or date i.e (20200807). How to show date in DD-MM-YYYY format??

Hemil Gandhi 8-Jul-20 6:59am View

I am using below mentioned query to match & update record. Plz guide on this

UPDATE t1 SET t1.[Recon] = 1 ,t1.[ReconDT]=getdate() FROM TEMP_AXIS t1 INNER JOIN TEMP_SBPP t2 ON t1.UTR = t2.UTR and t1.CrDr='CR' AND CAST(T1.Amount AS DECIMAL(10,2))=CAST(T2.dr AS DECIMAL(10,2)) and t1.[Recon] is null and t2.[Recon] is null

Hemil Gandhi 8-Jul-20 6:34am View

Hey buddy now I am stuck with another issue, some times @common appears twice in one table & single time in another table. Now how to deal with it??, No entry should be updated in both tables.

Hemil Gandhi 7-Jul-20 6:51am View

Got the answer, thanks for the trying though

Hemil Gandhi 7-Jul-20 6:51am View

Thank you very much buddy you saved my lots of effort....

Hemil Gandhi 19-May-20 13:23pm View

One more thing to add we have domain login setup for each end user.

Hemil Gandhi 19-May-20 13:19pm View

<authentication mode="Windows">
<authorization>
<allow users="*">
One more thing to add we have domain login setup for each end user.

Hemil Gandhi 19-May-20 13:03pm View

Finally you go the solution or not??, I have same requirement.

Hemil Gandhi 15-Apr-20 10:17am View

Sir sorry to bother you but i am beginner, so i dont get your solution. please elaborate it.

Hemil Gandhi 14-Apr-20 12:06pm View

question updated as i have tried multiple solutions , now i am stuck with object reference error.

Hemil Gandhi 14-Apr-20 11:27am View

have already done that

Hemil Gandhi 13-Apr-20 11:48am View

I have tried all other ways but got the same error of "data corrupted". Please suggest something else....

Hemil Gandhi 11-Apr-20 13:02pm View

actually i want to import excel data to database but not able to upload excel file, hence i have decided it to save as csv & then import it to DB, please suggest what should i do to full fill my requirement.

Hemil Gandhi 11-Apr-20 12:59pm View

You want me to do some setting changes in application pool??

will you please tell me exactly what i should do ??
Thanks in advance

Hemil Gandhi 11-Apr-20 5:19am View

how shall i record log so that i came to know that system is facing error at which line??

Hemil Gandhi 11-Apr-20 4:29am View

Protected Sub CreateDirectory()
Dim Upath As String = "~/Uploads/" + CDate(Today.Date).ToString("yyyyMMdd")
Dim folderPath As String = Server.MapPath(Upath)
'Check whether Directory (Folder) exists.
If Not Directory.Exists(folderPath) Then
'If Directory (Folder) does not exists. Create it.
Directory.CreateDirectory(folderPath)
End If

Dim bkppath As String = Upath + "/" + "BKP"
Dim bfolderPath As String = Server.MapPath(bkppath)
'Check whether Directory (Folder) exists.
If Not Directory.Exists(bfolderPath) Then
'If Directory (Folder) does not exists. Create it.
Directory.CreateDirectory(bfolderPath)
End If
End Sub

I have made sure that they exist.

Hemil Gandhi 11-Apr-20 4:17am View

Dim Upath As String = "~/Uploads/" + CDate(Today.Date).ToString("yyyyMMdd")
Dim excelPath As String = Server.MapPath(Upath + "/BKP/") + Path.GetFileName(FileUpload1.PostedFile.FileName)
Dim csvPath As String = Server.MapPath(Upath) + "/" + Path.GetFileNameWithoutExtension(FileUpload1.PostedFile.FileName) + ".csv"

I am using above paths first i am copying original file to uploads/yyyymmdd/bkp folder & then saving csv file to uploads/yyyymmdd/ path, i have checked that system is able copy files to bkp folder but while saving csv it is throwing error. i have already provided necessary rights to folder.

Hemil Gandhi 7-Apr-20 13:33pm View

Thanks, Solution Worked

Hemil Gandhi 7-Apr-20 8:29am View

Thanks your query really worked.

Hemil Gandhi 6-Apr-20 9:28am View

some how i have figured out the solution, problem was in exporting data not in inserting data

Hemil Gandhi 2-Apr-20 12:10pm View

Can you please help me out with the best solution, if you provide your email, I will share file for better understanding.

Hemil Gandhi 2-Apr-20 12:08pm View

Thanks advice, I have done changes accordingly

Hemil Gandhi 29-Mar-20 1:04am View

hi , have you developed the solution. Beacuse I am also looking for reconciliation software for my two different banking accounts.

Comments by Hemil Gandhi (Top 49 by date)