In a sql server 2012 database, I have a called that is declared as varchar(max) where the column is called stringtemplate.
I want to update the value in the column with the value listed below, however the update statement does not work. There is a problem with the set statement. The double quotes or single quotes around the entire value does not stay.
Thus can you tell me what I can do to make the following sql work:
set stringtemplate = '
To the &PAR_NAME.EVAL of &STU_FNAME.EVAL &STU_LNAME.EVAL &PERMNUM
&PAR_ADDR.EVAL&PAR_CITY.EVAL, &PAR_STATE.EVAL &PAR_ZIP.EVAL
Dear &PAR_NAME.EVAL and &STU_FNAME.EVAL &STU_LNAME.EVAL:
This letter is to inform you that &STU_FNAME.EVAL has the equivalent of 5 or more unexcused absences this school year. We believe student attendance in school is a key component to school success, so it is very important for all children to develop habits of good attendance. Poor attendance contributes to failing grades, decreased learning opportunities, lower academic achievement and may limit your child's opportunities to be involved with school activities.
Please call me at PHONE NUMBER to discuss these absences. During this phone conference we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance.
I have scheduled an attendance review on DATE at TIME. We will meet at PLACE located at ADDRESS. Please check in at the main office upon your arrival. During this meeting we will address concerns and issues that may be contributing to the absences, and develop a collaborative plan to try to improve attendance. The student and parent should attend this review. If you cannot attend this meeting please contact me at PHONE #.
We are notifying you so that together we can address all issues that may be contributing to these absences. Communication between the home and school is very important and we request that parents call the school each and every day that a student is going to be absent. Let us work as partners to make your child successful in school.
School Support Liaison/ Attendance Designee
&SCHOOLNAME.EVAL' from test.dbo.customer a where a.custid=6789