Đã hoàn thành

Create a MS SQL Function

I need code for a ms sql function that will parse a comma separated string of names to the first 10 values if the number of items is above 50 and then check to see if a certain name is included in that string. If it is included then just add an ... et al to the end but if it is not in the string then remove the last value and add the new item and then ... et al. So both string will have a total of 10 names. I have the code that counts the number of items in the string:

so if the string is:

Declare @authorCount int

SELECT @authorCount = len(@Authors) - len(replace(@Authors, ',', ''))

so then you would need to pull the first ten name

Name List: = O'Shaughnessy JA, Kelloff GJ, Gordon GB, Dannenberg AJ, Hong WK, Fabian CJ, Sigman CC, Bertagnolli MM, Stratton SP, Lam S, Nelson WG, Meyskens FL, Alberts DS, Follen M, Rustgi AK, Papadimitrakopoulou V, Scardino PT, Gazdar AF, Wattenberg LW, Sporn MB, Sakr WA, Lippman SM, Von Hoff DD

Check if Fabian CJ is in the list

final output would be because it is in the list

O'Shaughnessy JA, Kelloff GJ, Gordon GB, Dannenberg AJ, Hong WK, Fabian CJ, Sigman CC, Bertagnolli MM, Stratton SP, Lam S ...et al

Check if Von Hoff DD is in the list

final output would be because it is not in the list

O'Shaughnessy JA, Kelloff GJ, Gordon GB, Dannenberg AJ, Hong WK, Fabian CJ, Sigman CC, Bertagnolli MM, Stratton SP, Von Hoff DD ...et al

Kĩ năng: Lập trình cơ sở dữ liệu, Microsoft SQL Server

Xem nhiều hơn: sql scalar function example, user defined functions in sql server 2008 with examples codeproject, types of user defined functions in sql server, create function oracle, sql user defined functions w3schools, sql server function return table, sql user defined function example, sql user defined functions tutorial, create dll sql calls, sql function calculate date, create gui sql database, sql function delivery receipt, php create field sql table, vacation days sql function, sugarcrm create call sql, php script create xml sql, create joomla sql dropdown box menu, find holiday sql function, create paragraph sql database, create filter sql database

Về Bên Thuê:
( 138 nhận xét ) Charleston, United States

ID dự án: #17748539

Được trao cho:

mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in MS SQL database extensively and have completed many projects on it, I can help you in developing functions as you mentioned in the given example Thêm

$30 USD trong 1 ngày
(21 Đánh Giá)
4.3

6 freelancer đang chào giá trung bình $33 cho công việc này

sreenivas2903

hi please let me know the requirements and i will complete asap. if you are interested ping me for more info

$55 USD trong 1 ngày
(11 Nhận xét)
3.9
$20 USD trong 20 ngày
(2 Nhận xét)
3.0
NadirBouchama

Hello, I am excellent in PHP / MySQL / Js and I have great knowledge in Database programming for many years and I realized many projects similar to yours. I am ready to create your script... Can you please provide me m Thêm

$20 USD trong 1 ngày
(2 Nhận xét)
2.1
freelancernewtec

Hello, I would like to take this assignment. I am having 14 years of experience on web development, deployment and project management. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript/JQuery •C# Thêm

$50 USD trong 1 ngày
(1 Nhận xét)
1.8
IbrahimAmeera

Dear sir I am an expert in databases. I can do these functions with high professionalism and I can do what you want in the databases I am happy to talk with you Greetings Ibrahim

$20 USD trong 1 ngày
(2 Nhận xét)
0.6