Any query to return the execution time for another query?

Hi,
I prefer a query. Otherwise, a stored procedure will do.
Thank you in advance for enlightening me.
PradeepTry:
declare @.start datetime
set @.start = getdate()
-- do your query here
print datediff (ms, @.star, getdate())
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Pradeep" <pradeep@.tapadiya.net> wrote in message
news:1142815296.712493.28970@.i39g2000cwa.googlegroups.com...
Hi,
I prefer a query. Otherwise, a stored procedure will do.
Thank you in advance for enlightening me.
Pradeep|||Pradeep (pradeep@.tapadiya.net) writes:
> I prefer a query. Otherwise, a stored procedure will do.
> Thank you in advance for enlightening me.
In additions to Tom's suggestion, you can also use SET STATISTICS TIME ON.
However, I prefer using getdate() as Tom's example. After all, what
matters at the end of they day, is the wallclock time for a query.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Any embedded tool in win2003 or SSIS for extracting the files from ZIP

Who knows whether exists embedded tool in win2003 or SSIS for extracting the files from ZIP?

Thanks in advance.

SSIS can execute a command line zip utility to extract files.|||

Do u mean that it should use 3rd party tool(like winzip command line)?

I dont wanna do that cuz of commercial purpose.

I just wanna know any tool in windows 2003 server or something banding in the SSIS

|||You're going to have to use a 3rd party utility.