Inserting multiple values in table with Identity column from which i specified value

See more:

SQL-Server

SQL-Server-2008

Create table  #Temp_BrandSequence
(
    SequenceNo INT identity,
    BrandID BIGINT,
    ChannelID BIGINT,
    CreatedBy INT,
    CreatedDate DATETIME
)
SET IDENTITY_INSERT #Temp_BrandSequence ON
INSERT INTO #Temp_BrandSequence (SequenceNo,BrandID,ChannelID,CreatedBy ,CreatedDate)
SELECT @ChannelCount1+1,P.RecordID,2,123,getdate()FROM @Brand_S B
INNER JOIN ProductLevelDetails  P ON (P.RecordCode=B.BrandCode and P.LevelId=3)
WHERE Flag='I' AND PId IS NOT NULL;

this generate same identity values for all row


insert Query have more than one row
What I need is
I have to generate Values in Identity column from which i specified