Viewing 15 posts - 676 through 690 (of 1,464 total)
October 18, 2018 at 1:54 pm
You need to check for the number of failed subjects firstDECLARE @PassMark int = 35;
SELECT
cs.name
, TotalMarks = SUM(cs.mark)
...
October 18, 2018 at 1:13 pm
Getting closer. When I try the line below...it works...
October 18, 2018 at 12:04 pm
October 18, 2018 at 11:01 am
October 17, 2018 at 10:20 pm
October 17, 2018 at 4:13 am
ADOCmd.Parameters.Append ADOCmd.CreateParameter("intResult", adInteger, adParamInput, 6, intResult)
Can someone please tell me where I'm...
October 16, 2018 at 10:10 pm
October 16, 2018 at 1:25 pm
October 16, 2018 at 3:48 am
Here is a link to some Common Date Routines
October 15, 2018 at 2:59 pm
October 15, 2018 at 2:51 pm
Sorry, but that doesn't read right. I seem to be having trouble articulating what my mind is thinking.
Perhaps the CONVERT() documentation might help.
October 15, 2018 at 2:10 pm
October 15, 2018 at 2:07 pm
Thanks for your suggestion, but when I try it, I'm getting an "Explicit conversion...
October 15, 2018 at 1:47 pm
It appears that your ReportDateYearMonthg is a char(6) value.
This should do the trickSELECT DATEADD(MONTH, -1, CONVERT(date, ppr.ReportDateYearMonth+'01', 112)) AS PeriodEndCalendar
October 15, 2018 at 1:30 pm
Viewing 15 posts - 676 through 690 (of 1,464 total)