SQL Query Creation for Shortcut Key Updates
₹600-1500 INR
Pagado a la entrega
I'm in need of an experienced MS SQL Server professional who can help me create a SQL query to add new shortcut keys based on specific rules.
Key Requirements:
- Understanding of SQL and experience with MS SQL Server.
- Ability to create SQL queries that add new shortcut keys to specific tables.
- Experience working with SQL schemas, even though the focus on certain elements will be determined later.
Your task will include:
- Creating a SQL query that adds new shortcut keys to specific tables.
- Ensuring the query is efficient and does not disrupt existing database operations.
Please include relevant experience in your bid. I look forward to working with you.
Schema
select id, menutype menuid, name, parent, parentid, shortcutkey
from dbo.tbl_shortcutkeys
Rules
1. Shortcut key should be unique for rows under the same parent id
2. Shortcut key should use a combination of Ctrl, Alt and a single alphabet (in capital Letter) without use of any numbers or special characters.
3. It can be a combination of ctrl and a single alphabet or alt and a single alphabet or ctrl, alt and a single alphabet
4. The alphabet has to be derived from anywhere between the spelling of the value of name field
5. the seperate between ctrl, alt and alphabet will be the plus symbol i.e. "+"
6. It should not assign any system or browser reserved shortcut keys
7. It should not assign any shortcut keys which are already present in the shortcut key field which would have been assigned in the earlier run
8. the alphabet has to be derived from the value of the name field
Nº del proyecto: #38659811
Sobre el proyecto
Adjudicado a:
Hello, I have extensive experience working with MS SQL Server, including designing complex queries and schema management. I can help you create an efficient SQL query to add new shortcut keys following the rules you’v Más
16 freelancers están ofertando un promedio de ₹3232 por este trabajo
Hello I have several years of experience with MS SQL server, and I have completed a lot of similar projects on this platform. It looks like easy task to complete in 1-2 hours of working time
I am well-versed in SQL and PLSQL, with hands-on experience in MySQL and SQLite. My background includes developing efficient database solutions and writing optimized queries for both small and large-scale projects. I h Más
Hey there, I am interested in your project to create a SQL query for adding new shortcut keys based on specific rules. With a strong understanding of SQL and extensive experience working with MS SQL Server, I can effic Más
Dear friend, I am excited to apply for the position of creating SQL queries for adding new shortcut keys in MS SQL Server. With extensive experience in SQL and a deep understanding of database management, I am well-eq Más
