Created
June 23, 2010 10:14
-
-
Save jmcervera/449735 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT count(*) as TotalRows from (SELECT TOP 1000000000 [repuestos].id FROM [repuestos] LEFT OUTER JOIN [consumos_reales] ON consumos_reales.repuesto_id = repuestos.id LEFT OUTER JOIN [consumos_previstos] ON consumos_previstos.repuesto_id = repuestos.id WHERE (consumos_reales.repuesto_id is not null OR consumos_previstos.repuesto_id is not null ) GROUP BY [repuestos].id ORDER BY MIN(codigo)) tally | |
SET NOCOUNT ON DECLARE @row_number TABLE (row int identity(1,1), id int) INSERT INTO @row_number (id) SELECT [repuestos].id FROM [repuestos] LEFT OUTER JOIN [consumos_reales] ON consumos_reales.repuesto_id = repuestos.id LEFT OUTER JOIN [consumos_previstos] ON consumos_previstos.repuesto_id = repuestos.id WHERE (consumos_reales.repuesto_id is not null OR consumos_previstos.repuesto_id is not null ) GROUP BY [repuestos].id ORDER BY MIN(codigo) SET NOCOUNT OFF SELECT id FROM ( SELECT TOP 30 * FROM ( SELECT TOP 60 * FROM @row_number ORDER BY row ) AS tmp1 ORDER BY row DESC ) AS tmp2 ORDER BY row | |
SELECT [repuestos].[id] AS t0_r0, [repuestos].[codigo] AS t0_r1, [repuestos].[descripcion] AS t0_r2, [repuestos].[unidad_medida] AS t0_r3, [repuestos].[familia] AS t0_r4, [repuestos].[existencias] AS t0_r5, [consumos_reales].[id] AS t1_r0, [consumos_reales].[orden_trabajo_id] AS t1_r1, [consumos_reales].[repuesto_id] AS t1_r2, [consumos_reales].[cantidad] AS t1_r3, [consumos_reales].[fecha] AS t1_r4, [consumos_previstos].[id] AS t2_r0, [consumos_previstos].[medida_prevencion_id] AS t2_r1, [consumos_previstos].[repuesto_id] AS t2_r2, [consumos_previstos].[cantidad] AS t2_r3 FROM [repuestos] LEFT OUTER JOIN [consumos_reales] ON consumos_reales.repuesto_id = repuestos.id LEFT OUTER JOIN [consumos_previstos] ON consumos_previstos.repuesto_id = repuestos.id WHERE (consumos_reales.repuesto_id is not null OR consumos_previstos.repuesto_id is not null ) AND [repuestos].id IN (10030, 10036, 10037, 10038, 10041, 10046, 10064, 10065, 10067, 10068, 10085, 10090, 10103, 10142, 10364, 10425, 10428, 10430, 13821, 13825, 13841, 13845, 13846, 13847, 13842, 13851, 13856, 13858, 13863, 14200) ORDER BY codigo | |
SELECT count(DISTINCT [repuestos].id) AS count_all FROM [repuestos] LEFT OUTER JOIN [consumos_reales] ON consumos_reales.repuesto_id = repuestos.id LEFT OUTER JOIN [consumos_previstos] ON consumos_previstos.repuesto_id = repuestos.id WHERE (consumos_reales.repuesto_id is not null OR consumos_previstos.repuesto_id is not null ) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment