WayneS (7/8/2009)
karthimca07 (7/8/2009)
Hi All,
Tab_Token_Master(Transid,Token_starts_from,Token_Ends_To,Token_value)
Tab_Token_Details(Transid,Token_No,Token_Value,Token_Status)[p]The first table is used to store the token starting number and end number.[/p]
[p]for example (staring number)1 to 100(ending number). so i have to insert token1,token2...token100 in tab_Token_details table.[/p]
[p]how can i insert that number of records using stored procedure?
is there for loop to do this task?
plz help me in this issue?
thnks in advance[/p]
declare @Transid int, @TokenStart int, @TokenEnd int, @TokenValue int
insert into dbo.Tab_Token_Details (Transid, Token_No, Token_Value, Token_Status)
select
@Transid,
N,
@TokenValue,
'A' -- or whatever your status field should be
from dbo.Tally
where N between @TokenStart and @TokenEnd
If you don't have a tally table, search this site... it's explained and used frequently.
[p]the first table Tab_Token_Master is used to store the token generation and the second table used to store the all generated tokens.[/p]
Tab_Token_Master
-----------------------------------------------------------------
Transid Token_starts_from Token_Ends_To Token_value
-----------------------------------------------------------------
trans01 101 105 100
------------------------------------------------------------------
Tab_Token_Details
-----------------------------------------------------------------
Transid Token_No Token_Value Token_Status
-----------------------------------------------------------------
trans01 101 100 0
trans01 102 100 1
trans01 103 100 0
trans01 104 100 1
trans01 105 100 1
-----------------------------------------------------------------
in the above example data 5 tokens generated. im calling insert statement in a for loop in vb.net. it become very slow. so im looking for stored procedure