October 18, 2005 at 9:39 am
Hi experts,
I have a Job_Table table with 3 columns : job_code, job_title,job_description.
Job_Code Job_Title
1 Team Member
2 Shift Coordinator
3 Assistant Manager
4 General Manager
I need to load the job description for every job and the job description is in a text document.
The content looks like:
Team member:
· Following all kitchen procedures per OPS specification to ensure our guests receive great food.
· The upkeep and cleanliness of the restaurant by using our Clean and Safe program.
. Displaying a friendly demeanor to give an experience in a friendly and personalized manner.
Requirements:
1.
2.
Shift Coordinator:
· Consistently following all standard preparation procedures without Mgmt supervision.
· Assisting Mgmt in training all kitchen procedures
· Monitoring all hold times marked
Requirements:
1.
2.
Can someone guide me what is the easiest way to insert the description?
October 18, 2005 at 11:48 am
You haven't provided enough info to tell you what's the best:
Is it a one time only or recurring need (e.g. weekly load)?
Do you wish to preserve formatting (like the bullets that appear to be included)?
Is it going into a varchar or text datatype?
How many jobs/descriptions?
... etc...
If it is only the four, I'd do it all manually.
If it's something more massive, I'd look into preprocessing macro (text) utilities.
Or the SQL geek in me might BCP the text file into one TEXT datatype staging table, then parse it using substring/patindex loops to chop it out into title/description table. (Which would only work if the description will fit into a varchar variable.)
(NOTE: you can use patindex on text fields to find things, and substring to pull out pieces and put them into varchar variables.)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply