Hello,

It is solved by restarting our ERP's service.

Thanks for your reply.

It was configuration issue after the upgrade.

It wasn't too difficult that I was thinking about.

Thanks

R.P.Rozema (5/17/2016)

---

Jason A. Long (5/16/2016)

---

RV16 (5/13/2016)

---

Thanks.

You mean If I want to count number of students according to crs_cde then I should write like this

count(sch.id_num) OVER (PARTITION BY ss.CRS_CDE) "No of...

Thanks.

You mean If I want to count number of students according to crs_cde then I should write like this

count(sch.id_num) OVER (PARTITION BY ss.CRS_CDE) "No of student"

I just want to verify...

Thanks for your suggestion. I looked at this forum and I will post question according to that.

I applied this query:

SELECT SM.yr_cde,

SM.trm_cde,

SS.room_cde,

SS.bldg_cde,

SS.loc_cde,

SS.crs_cde,

SM.short_crs_title_1,

SS.monday_cde,

SS.tuesday_cde,

SS.wednesday_cde,

SS.thursday_cde,

SS.friday_cde,

SS.saturday_cde,

SS.sunday_cde,

SS.begin_tim,

SS.end_tim,

SS.days_tim_ovrid,

SS.begin_dte,

SS.end_dte,

SS.comment_txt,

SS.seq_num_2,

SM.x_listed_parnt_crs,

count(SCH.ID_NUM) "No of student" --...

I tried to use group by but it gives me different rows than original one

Thanks.

I solved this issue. I just replaced the drop date cursor code with add date course. I copied add date course cursor to drop date course and I stop...

drew.allen (5/10/2016)

---

Andrew P (5/9/2016)

---

Have you tried CAST(STUDENT_CRS_HIST.JOB_TIME AS DATE)?

The below query would give you a list of distinct dates.

SELECT DISTINCT CAST(STUDENT_CRS_HIST.JOB_TIME AS DATE) AS JOB_DATE

FROM STUDENT_CRS_HIST

For an alternative, check...

Thanks for your reply. I appreciated...

Hello,

I could solve this error message using convert and mid function. I am not using cast but I convert datetime datatype to nvarchar and then just use mid function with...

datetime with cast function creating this problem.

SELECT section_master_v.yr_cde,

section_master_v.trm_cde,

...

I already remove same image with different names through del command. We are using one software to make badges. By that software, when our librarian takes a picture of person...

The best way to copy student image is using robocopy instead of sql server scripts

So I just used that way:

And now its solved. So I just put answer anyone who...

Yes, same image with different name

We have one software which creates student badges.By that way we capture the images.That images stores in image folder. Right now we rename image using firstname,lastname. Now when student badge...