Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
faizq
Starting Member
1 Post |
 Posted - 2015-02-22 : 19:45:57
|
| Hello, I needed some simple help in SQL Server, given below are my two questions.I am looking at making a SQL Server Procedure which uses cursors to detect some data entry mistakes. 1) I have a query joining two or three tables and returning me a list of rows. I would like to compare the Name column in this list using a like operator and report back any names which are similar. How can this be done ? If possible please send me a brief skeletal code to do the same.2) I am using a query to join names of employees with languages they speak. The query works fine but for employees who speak more than 1 language, the record gets repeated with a new line for every new language they speak, instead of doing this, I would like to concatenate their languages in 1 column and report back 1 row per employee. Is this possible ?If yes please send me the brief skeletal code to do this on faizq@yahoo.comThanksFQFQ |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-22 : 22:05:17
|
| You Dont need cursors for that unless you want a slow solution. Looks like you might need full text indexes though |
 |
|
|
|
|
|
SQL Server Procedures Questions