Fajne :)

Choc chyba mniej tajemniczo by to wygladalo tak:


CREATE TABLE Numbers1 (Number int NOT NULL PRIMARY KEY);
WITH n (j) AS (
SELECT j = 0
UNION ALL
SELECT j = j + 1 FROM n WHERE j < 9999)
INSERT Numbers1 (Number)
SELECT i = j + k + 1
FROM n
CROSS JOIN
(SELECT k = j * 10000
FROM n
WHERE j < 100) n2
WHERE j + k + 1 < 1000000
OPTION (MAXRECURSION 9999)

;-)

--
KN

-----Original Message-----

Albo jeszcze tak:

CREATE TABLE Numbers1 (Number int NOT NULL PRIMARY KEY);
WITH n (j) AS (
SELECT j = 0
UNION ALL
SELECT j = j + 1 FROM n WHERE j < 32000)
INSERT Numbers1 (Number)
SELECT i = j + k + 1
FROM n
CROSS JOIN
(SELECT k = j * 32001
FROM n
WHERE j < 32) n2
WHERE j + k + 1 < 1000000
OPTION (MAXRECURSION 32000)


Pozdrawiam
Marcin


--



[Message truncated. Tap Edit->Mark for Download to get remaining portion.]

--
Archiwum grupy: http://niusy.onet.pl/pl.comp.bazy-danych.msaccess