Skip to content
Advertisement

Tag: sqlhelper

Return a 0 if no rows are found in Microsoft SQL Server

I need your help with this query. My table CSO_EMP_ORG_DPM_VIE has a column with different keys. Column name is EXT_KEY. When I receive the same key number in EXT_KEY, I want the SQL code to count the duplicates using this query: This is working so far, but when it has no duplicate keys (numbers) in the column, I want it

Advertisement