2nd way is I declared the @table and inserted the XML node level records into @table variable and then doing update joining the @table with main table which I need...

Above question if resolved.I need more info on whare clause for OPENXML. Can I use OPENXML like this :

select State,Effectivedate FROM OPENXML(@XmlTable, '/TemplateDto', 2) ...

This I read in BOL. And I am using SCOPE_IDENTITY(). My question if different how we can get the auto generated values every next day starting from 1.

Thanks for your valuable response.I have mentioned the inserts into customer and then address table. Will it be accurate to add customerid in address table after getting it from scope_identity()...

I am new to sql server and I need your suggestions:

which one is the best for PK generation(@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT ). If i have transactions like this.

begin tran

Insert...

I also did the same (excel-> access then sql server.). It worked.