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
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. I am available to discuss now and start on the work.
Looking forward to have further project discussion on chat.
Thanks.
Vimal Arora
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
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# and VB.Net SOLID Design Principles
•MS SQL, AZURE SQL, MySql and non-relational databases like Azure Table storage, Azure Document Db and MongoDb
•Entity Framework (Database first, Code first and OData)
•Azure Service Bus, N Service Bus and Azure Service Fabric
•AWS: EC2/S3/Elastic Beanstalk/RDS/LightSail
•Restful API Development (using C#) and deployment on cloud
•Team City and Octopus Server for Continuous Integration and deployment
•VSS/TFS/GitHub/SVN/Bitbucket/VSO
•Agile/Scrum/Kanban/Zendesk
•JIRA/Confluence
•Unit tests using nUnit and xUnit framework
•Integration testing
•Acceptance/ Behavioral testing using SpecFlow
•API Authentication using JSON web token
•JSON format for information exchange
•Domain Driven Design (DDD)
•Command Query Responsibilities Segregation (CQRS)
•Owin Web hosting
•QuartzNet for Cron job
•SSRS and Crystal Reports
•Integration and implementation of Carrier(DHL, UPS, FedEx,TNT) APIs in the ASP.Net application
•Integration and implementation of payment gateway(PayPal, PayUMoney) APIs in the ASP.Net application
Working on tools like:
Zendesk, Autofac, AutoMapper, SeriLog, Elastic-Search, Kibana, RoboMongo, RabbitMQ, TopShelf
Looking forward for further discussion and to start.
Best Regards