Create a MS SQL Function

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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

Programiranje podatkovnih baz Microsoft SQL strežnik

ID projekta: #17748539

Več o projektu

5 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

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 Več

$30 USD v 1 dnevu
(37 mnenj)
4.9

5 freelancerjev ponuja v povprečju za $35 na tem delu

sreenivas2903

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

$55 USD v 1 dnevu
(14 ocen)
4.2
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 v 1 dnevu
(5 ocen)
2.3
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# Več

$50 USD v 1 dnevu
(1 Ocena)
1.8