Error en consulta SQL.
Error: Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Source: Microsoft OLE DB Provider for SQL Server
Query: select count(*) as contador from ( select distinct a.id_piso from Vista_Pisos A inner join tbl_pisos p on a.id_piso=p.id_piso where 1=1 and IsNull(p.Activo_Origen1,0)<>0 and a.Corporate=1 and a.id_idioma=1 and a.id_Ciudad=2 group by a.id_piso ) as tabla