Calculating column, query based on text

Question

Calculating column, query based on text

ez1138 1

Hi, I have a number of columns that I would like to calculate a value in another columns based on certain text. For three individual columns, one for "Pass", "Fail", and "In Progress", I would like the query to count the number of columns that have pass are entered in and so forth for the others.

Olaf Helper 47,621 Reputation points

2021-02-18T14:11:27.933+00:00

Please post table design as DDL, some sample data as DML and the expected result.
Yitzhak Khabinsky 27,196 Reputation points

2021-02-18T14:12:24.447+00:00

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
EchoLiu-MSFT 14,626 Reputation points

2021-02-24T07:02:34.267+00:00

Do you have any update?

1 answer

Your answer

Olaf Helper 47,621 Reputation points

2021-02-18T14:11:27.933+00:00

Please post table design as DDL, some sample data as DML and the expected result.
Yitzhak Khabinsky 27,196 Reputation points

2021-02-18T14:12:24.447+00:00

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
EchoLiu-MSFT 14,626 Reputation points

2021-02-24T07:02:34.267+00:00

Do you have any update?

Answer 1

EchoLiu-MSFT 14,626

Could you please share us your table structure (CREATE TABLE …) and some sample data(INSERT INTO …)
along with your expected result? So that we’ll get a right direction and make some test.

0 comments

Share via

Calculating column, query based on text

1 answer

Your answer