question

NedStark1003-9728 avatar image
0 Votes"
NedStark1003-9728 asked SeeyaXi-msft commented

How to give red color to rows when Employee active status is zero?

I have to give red to the rows where employee active status is zero in SQL

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NedStark1003-9728,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

SQL Server as it provides data, not more.
"Coloring" a displayed result is the task of the frontend and you didn't mentioned, which one you use.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @NedStark1003-9728,

As Olaf mentioned, > SQL Server as it provides data, not more.
I have put a statement below about selecting the user process which contains detailed information such as SPID, Login. Also you can use sp_who2.

 SELECT * FROM sys.dm_exec_sessions WHERE is_user_process = 1;

Hope this could give you some help.

Best regards,
Seeya


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.