Error en consulta SQL. Error: Transaction (Process ID 67) 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 p.lowcost=1 and a.id_idioma=3 and a.id_Ciudad=1 group by a.id_piso ) as tabla
|