So if I understand you correctly instead of having 3 columns in the Job_Requisitions table, RequisitionNumber, JobID, and LocationID , you would have a 4th column being the...

the while loop creates the 12 digit random character string subtracting 1 from the

@len variable in each iteration until it has all 12 characters

I will have to look into...

yep both against the same db

I originally had this in the Exists statement in the sproc.

IF EXISTS(SELECT RecordID FROM dbo.EvalData WHERE SecAccount=@Secondary AND...

Positive. The secondary account code is a 6 character code. it has nothing to do with a person's name i just happened to create one similar...

Years ago, while I was working in a different industry, all managers of my employer were required to take a course in positive reinforcement. Basically positve reinforcement is doing...

issue resolved

Thanks Much You have been a great help 🙂

we use dbo.sp_Whatever when we execute the sprocs. I was told this will make it not look at the master table is that incorrect?

The Application table will only hold one record(The UserID in this case is the Primary Key on this table). However, the Application_Locations table may hold many records for each UserID....

Yes, the answers are always available. the display of the questionairre is built from those tables. I made a change to the way we are storing...

Yes that did not make any changes to the output

The input would look like this

SELECT udf_GetCheckboxAnswers (218, '2, 4, 5') AS AnswerString

The intended output in this example would be

Tuesday, Thursday, Friday

The second one I showed outputs Friday....

Yes,  the UserId column is Unique.  They are set up as a foreign key to another table where they are the primary key.  

yes, they have the square brackets around them.  My concern is will these cause a problem.   I have renamed some of the columns because they used reserved words.   I am...