15,796,299 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Python questions
View PHP questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
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.
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.
Show More