Thanks, let me give it a try

It has records like each row for each student, each absent date.

Thank you, I run on my table, the result seems not correct. Your table looks good but for each student there is only one met threshold, there should be any...

You guys are all great, let me try each one to see which one works better for my case! Thanks much

Thank you, the insert will be only used for our data conversion and migration from old application database to new application database, it will be removed later after data conversion.

Also...

By looking at the code again, I see it really just updated the inserted.row, not for all, so it is not too bad.

Each time we talked about trigger...

Thank you, let me write an email to the consultant to find out.

Thanks all.

We do have some front end checking and validation like if user changed the status to anything means end, then closed date is required message pop up before they...

Grant Fritchey (10/21/2016)

---

. Most of the time, that just doesn't offset all the pain involved in maintaining the filestream info. I'd prefer to simply link to the file and deal...

From the two database ends I did a search cannot find any code that refer each other. No FK, no joins related to each other. In the main application database...

Thanks, Yes, I scheduled a cmd forfile job in SQL agent to delete the files.

thanks, as long as the job returns error, that is good enough, then I can go to the text file to check the error

yes, sometimes I use stored procedure to return result.

So for those, I give user the public role, and grant execute to the stored procedure.

Is that OK?

Thanks,

I found the reason.

The custom branding is not supported in standard edition, only supported in Enterprise.

See below

https://msdn.microsoft.com/en-us/library/mt742500.aspx

Yes, by directly entering the URL you told me I can see, there is a download and remove, and upload brand package there.

But it is still not on the left...