seasonings
EXEC sp_xml_preparedocument @idoc OUTPUT,@doc SELECT * FROM
OPENXML(@idoc,'/Categories/CategoryInfo',2) WITH (
CategoryID int '@CategoryID',
CategoryName VARCHAR(100) 'CategoryName', [Description] VARCHAR(100) 'Description' )