İki tablom var. 1. Tabloda ürün ve miktarı ('XXXX',10) ('YYYY,5) yazıyor. 2. tabloyu 1.tablodaki ürünlerin adlarını miktarı kadar eklemem gerekiyo. bunu tek query ile yapabilirmiyiz? yoksa eski usul döngü içinde mi yaparız?
SELECT
T1.URUN
FROM URUN_MIKTAR T1
INNER JOIN
(
SELECT
T1.SAYI * 1 + T2.SAYI * 10 + T3.SAYI * 100 + T4.SAYI * 1000 + 1 AS SAYI
FROM (SELECT 0 AS SAYI UNION ALL SELECT 1 AS SAYI UNION ALL SELECT 2 AS SAYI UNION ALL SELECT 3 AS SAYI UNION ALL SELECT 4 AS SAYI UNION ALL SELECT 5 AS SAYI UNION ALL SELECT 6 AS SAYI UNION ALL SELECT 7 AS SAYI UNION ALL SELECT 8 AS SAYI UNION ALL SELECT 9 AS SAYI) T1
LEFT JOIN (SELECT 0 AS SAYI UNION ALL SELECT 1 AS SAYI UNION ALL SELECT 2 AS SAYI UNION ALL SELECT 3 AS SAYI UNION ALL SELECT 4 AS SAYI UNION ALL SELECT 5 AS SAYI UNION ALL SELECT 6 AS SAYI UNION ALL SELECT 7 AS SAYI UNION ALL SELECT 8 AS SAYI UNION ALL SELECT 9 AS SAYI) T2 ON 1 = 1
LEFT JOIN (SELECT 0 AS SAYI UNION ALL SELECT 1 AS SAYI UNION ALL SELECT 2 AS SAYI UNION ALL SELECT 3 AS SAYI UNION ALL SELECT 4 AS SAYI UNION ALL SELECT 5 AS SAYI UNION ALL SELECT 6 AS SAYI UNION ALL SELECT 7 AS SAYI UNION ALL SELECT 8 AS SAYI UNION ALL SELECT 9 AS SAYI) T3 ON 1 = 1
LEFT JOIN (SELECT 0 AS SAYI UNION ALL SELECT 1 AS SAYI UNION ALL SELECT 2 AS SAYI UNION ALL SELECT 3 AS SAYI UNION ALL SELECT 4 AS SAYI UNION ALL SELECT 5 AS SAYI UNION ALL SELECT 6 AS SAYI UNION ALL SELECT 7 AS SAYI UNION ALL SELECT 8 AS SAYI UNION ALL SELECT 9 AS SAYI) T4 ON 1 = 1
) T2 ON T2.SAYI <= T1.MIKTAR
ORDER BY 1