Sorry if u misunderstood..

I did get yor CTE and able to work on it ...

I am inbetween working on my code and testing it.. just posted meanwhile..

Sorry again...

thanks This looks helpful .. I need to generate sequence with next 4 alpha numbers - aa00ab01,aa00ac02,

can you please help me with the complete/full output code ...

Thanks loads

Can you please please please recode and post and I shall look into and modify or test ?

Thanks for the great help

Thanks ! Can you please post the code if possible ?

Eiminating I and O - its needs to return 24*24*10*10*24*24*10*10 exactly 3 317760000 records .

That's fine with the data load if its slow.

but I need to get...

Hi, Thanks for the immediate Suggestion.

I am using below as Input query to load sequence records to destination table

SELECT ID, [Database].[dbo].[SequenceComplexNEW](ID) AS Sequence

FROM (SELECT n AS ID...

I need to load the output in database table.so I am trying to write a Sql stored procedure or function to return the sequence numbers and load the sequence numbers...

Solution is :

="Cnt: " & Format(CountRows("DataSet"), "N0")