you can use some sys tables (or any other available table) as kind of tally one:
INSERT YourTable (COMCOD, ACTCODE, ACTDESC)
SELECT TOP 10
3306 AS COMCOD
,180000 +
(ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) * 10 AS ACTCODE
,NULL AS ACTDESC
FROM sys.columns
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]