How do I increment an alphanumeric column by 1 for each successive record.
I have a column in an SQL query that has both alpha and numeric values.
Example. ColumnA
…
![SQL]()
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....
Read more- 61K Content
- 7.8K Contributors
Expert Spotlight
COG Lead Engineer
I'm Shaun Vermaak. I love tech and how it improves life and business. Did you find what you were looking for?
Advice Question
Research Question
Matrix multiplication
Matrix multiplication and transpose from Excel to SQL process calculation method how it can be done?
…
Troubleshooting Question
Stack Overflow in C# because of dataset.rowfiler statement
I'm trying to fix a stack overflow problem in a C# app. When a user signs on, the system gets their
…
Troubleshooting Question
Compare rows depend on conditions
Hello Expert,
I need help in sql. See the below data. If you see the first 2 lines
External_id =
…
Research Question
Capturing User Interactions in Power BI Service or Report Server Portal
Use case: I have a power bi report which is published in Power bi service and gave access to the
…
Troubleshooting Question
Set query rule how to join records
Hi Experts,
I have the following query that is supposed to show all records from DailyPostingsWGQry
…
Troubleshooting Question
how to use sql query to find matching records that uses regular expression?
I am creating a postgre database and a table as such
i have some_text field , which stores text
…
Troubleshooting Question
HTML, PHP
I am just learning HTML, and PHP but have extensive knowledge of VBA and MSAcess which may or may
…
Advice Question
Freelancing
Hi Teams,
I am working as sql developer and i really wanted to do freelancing can you guys guide me.
…
Troubleshooting Question
Efficient search for 1st record
Declare a cursor and select only 1 record matching the key in IBM i stored procedure on IBM i using
…
Advice Question
usage report for two date ranges
i am trying to write a mysql query to produce a usage report displaying the usage(max value -
…
Troubleshooting Question
monday.com Search formula
Monday.com formula returns “one of the parameters are invalid” if search string “+Sig” not found!
…
Advice Question
Output of IBM i NetServer Info (FILE SHARES) and the user permissions for users that can access those file shares
I am looking to generate a report that contains all file shares data and the users that have
…
Troubleshooting Question
Failure for certain records
SQL0727N An error occurred during implicit system action type "1". Information returned for the
…
Troubleshooting Question
What are the best practices for securing a REST API against common vulnerabilities such as SQL injection, cross-site scripting (XSS), and cross-site request forgery (CSRF)?
Securing REST APIs is critical to protect sensitive data and ensure the integrity of web
Troubleshooting Question
%sql SELECT JULIANDAY(R.ReturnDate) AS AverageDaysToReturn FROM SALES S JOIN RETURNS R ON R.OrderID = S.OrderID; julianday returning none values
This question is in reference to EE question: DateDiff not working with SQLite?
%sql SELECT
…
Troubleshooting Question
sql formula for Sage intelligence container drop leading zeros
In a Sage Intelligence container for Sage 100 I need a sql formula to drop the leading zero's out of
…
Research Question
performance related configuration guide for SQL 2022
Hi,
We are going to install SQL 2022 and we are now using SQL 2019, we are now trying to enable any
…
Advice Question
sql live projects
sql live projects
Troubleshooting Question
SQL Query - Return item value based on newest date
I am working on a query that a challenge for me. A customer can have muplite price sheets assgiend
…Explore solutions and more
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.