Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT CASE WHEN m.answer_value = 'Yes' THEN m.question_txt ELSE m.list_value_txt END AS 'Total_Closed_Cases_Where_the_CM', 0 as 'Number_Of_Closed_Cases' INTO #counts FROM #members OUTPUT FROM ABOVE CODE: Total_Closed_Cases_Where_the_CM Number_Of_Closed_Cases Worked AAA 0 Worked AAA 0 Worked AAA 0 Extended BBB 0 Extended BBB 0 Extended BBB 0 Extended BBB 0 Negotiated CCC 0 Negotiated CCC 0 Provided DDD 0 Provided DDD 0 Provided DDD 0 I WANT THE OUTPUT TO BE: Worked AAA 3 Extended BBB 4 Negotiated CCC 2 Provided DDD 3
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.