SQL Query - CASE Statement - URGENT

Nov 28 2016 5:10 AM

Hello all,

My Requirement is-

I have a table with details of - Devices, Subdevices and hostnames (all computer systems details).

Now, I want to display the result as -

1. When host name contains "scrap" or "temp" values, then Hostname must be blank.

2. When device type is ThinClient , then Hostname must be "N/A"

Please help me to make the query ..

Eg -

Original Table -

Output as

Answers (7)

how to filter Year from Datetimepicker