Click here to Skip to main content
15,885,366 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Here is the sql statement:
SQL
INSERT INTO BinarizeResults(url, [file],[state],Binarize,Binarize2,FilterGaussian,FilterMedianSmooth,HoughLines,OptimizeImageSize,PreprocessImage,RemovePepperNoise,RemoveSaltNoise,accuracy,Task_Length)
SELECT X.a.query('url'.value('.','VARCHAR(50)')),
       X.a.query('file'.value('.','VARCHAR(50)')),
	   X.a.query('state'.value('.','VARCHAR(20)')),
	   X.a.query('Binarize'.value('.','VARCHAR(6)')),
	   X.a.query('Binarize2'.value('.','VARCHAR(6)')),
	   X.a.query('FilterGaussian'.value('.','VARCHAR(6)')),
	   X.a.query('FilterMedianSmooth'.value('.','VARCHAR(6)')),
	   X.a.query('HoughLines'.value('.','VARCHAR(6)')),
	   X.a.query('OptimizeImageSize'.value('.','VARCHAR(6)')),
	   X.a.query('PreprocessImage'.value('.','VARCHAR(6)')),
	   X.a.query('RemovePepperNoise'.value('.','VARCHAR(6)')),
	   X.a.query('RemoveSaltNoise'.value('.','VARCHAR(6)')),
	   X.a.query('accuracy'.value('.','VARCHAR(6)')),
	   X.a.query('Task_Length'.value('.','VARCHAR(10)'))
FROM (
	  SELECT CAST(x AS XML)
      FROM OPENROWSET(
					  BULK 'C:\Users\Jarmendariz\Desktop\ocrbinarize.xml', SINGLE_BLOB
					  ) 
	  AS T(x)
	  )
AS T(x)
CROSS APPLY x.nodes('resultset/results/result') AS X(a);
Posted
Updated 21-Aug-14 3:06am
v3

1 solution

It looks like you've got your parentheses in the wrong place. Instead of:
SQL
X.a.query('url'.value('.','VARCHAR(50)'))

try:
SQL
X.a.query('url').value('.','VARCHAR(50)')
 
Share this answer
 
Comments
Herman<T>.Instance 21-Aug-14 10:40am    
sharp!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900