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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SQL Server Procedures Questions

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.com



Thanks

FQ

FQ

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
Go to Top of Page
   

- Advertisement -