The percentage you are seeing is the percentage relative to the batch.
Since there is only one query in batch it shows 100 percent.
If you had more than one statement for a eg if it was a stored proc, you would see this spread across the queries.
---------------------------------------------------------------------------------------------------------------------------------------------------- Roshan Joe
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]