xml importing in sql file

See more:

SQL

server

Hi,
I have a problem while inserting this xml file in sql server , it is inserting but the blank rows is inserting so Please help for this

CREATE TABLE #WorkingTable (Data XML)
INSERT INTO #WorkingTable
SELECT *
FROM   OPENROWSET(BULK 'D:\xml\Employee.xml',SINGLE_BLOB) AS data

/* Import the users records from the working table */

DECLARE  @XML  AS XML
SELECT @XML = Data
FROM   #WorkingTable
--drop table #WorkingTable
--select * from #WorkingTable
declare @hDoc  AS INT
EXEC sp_xml_preparedocument @hDoc OUTPUT ,@XML
INSERT INTO LeadStatusRepository
SELECT * FROM   OPENXML (@hDoc,'/NewDataSet/Table',1) with Employee

/* Clean up and empty out our temporary table */

EXEC sp_xml_removedocument @hDoc
DROP TABLE #WorkingTable