tag:blogger.com,1999:blog-7805972021499203804.post1994815936532406052..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: How to Exclude Weekends in SQL Query or Get Records Without WeekendsSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7805972021499203804.post-21735881503146071902019-02-07T00:22:50.646-08:002019-02-07T00:22:50.646-08:00How to get monthly attendance report in asp.net.I ...How to get monthly attendance report in asp.net.I have a table tblAttendance(ClassId,SectionId,StudentId,rollNo,AttStatust,Date,Monthcode).I want data like this<br />StudentId RollNo 01-01-2019 02-01-2019 ..... totalPresent TotalApsent<br />1001 01 P A 1 1<br />1002 02 A A 0 2 Deepakhttp://nanoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-61908575136389297422014-07-07T12:28:40.245-07:002014-07-07T12:28:40.245-07:00Hi can you please help me to get this statement to...Hi can you please help me to get this statement to exclude weekends, it doesn't recognize 'w' or 'dw' as weekdays, it still keeps calculating all days<br />totext(DateAdd ("d",20,{?maildt} ),"MMMM dd, yyyy")Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-47456130633869898022013-07-27T05:47:32.479-07:002013-07-27T05:47:32.479-07:00select top 50 * from TABLENAME where (DATENAME(dw... select top 50 * from TABLENAME where (DATENAME(dw, createdat)) <>'Saturday' and (DATENAME(dw, createdat)) <>'Sunday' -:KavishAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-34328897263723271712013-03-01T23:09:59.908-08:002013-03-01T23:09:59.908-08:00it works.....thnku sirit works.....thnku sirNikhil Kaduhttps://www.blogger.com/profile/10424033486105128141noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-52742283421746312462012-11-29T22:08:04.072-08:002012-11-29T22:08:04.072-08:00@Shrinivas...
if you want to get last four digits ...@Shrinivas...<br />if you want to get last four digits you need to use substring function for that check below post <br /><a href="http://www.aspdotnet-suresh.com/2012/04/sql-server-substring-function-example.html" rel="nofollow">http://www.aspdotnet-suresh.com/2012/04/sql-server-substring-function-example.html</a>Suresh Dasarihttps://www.blogger.com/profile/01337689983379917267noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-17153260193190017602012-11-29T21:56:52.594-08:002012-11-29T21:56:52.594-08:00Excellent Query...
Thanks a lot...
I have got o...Excellent Query... <br /><br />Thanks a lot...<br /><br />I have got one requirement that in my table i'm having with the column names Fname, Lname and mobileNo. For example Fname=abc, Lname=xyz, mobileNo=9012345678. Then the result should be like <br />string PersonId=abcxyz5678;<br /><br />From the above string object we can find out one thing that I am combining Fname,Lname,mobileNo shrinivashttps://www.blogger.com/profile/02473666810515616811noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-34041153821758148322012-11-29T00:12:33.081-08:002012-11-29T00:12:33.081-08:00Thanks a lot Suresh...
I needed these functionali...Thanks a lot Suresh...<br /><br />I needed these functionality some 4 months back and since i wasn't able to do it in SQL , i'd to implement these logic from front end...<br /><br />Wish you'd written this article earlier...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-46290692910360125442012-11-28T20:30:15.876-08:002012-11-28T20:30:15.876-08:00This comment has been removed by the author.SImplyAsphttps://www.blogger.com/profile/04536540222013342142noreply@blogger.com