Thanks for replies

How to add Top into "select min([date]) from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'" without using sub query?

You mean "select min([date]) from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'"? But we want to select minimum from top 100 rows

What if we don't want to sort the date? Is there any easy method?

I don't think that is correct,because our query returns min(date) from top 100 rows which satisfies where condition But i don't find that in your query

sorry for that,

Actually my query contains where clause in sub query

SELECT min([date]) FROM entries WHERE [date] IN (select top(100) [date] from entries WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013' ...

Which is the best method by which i can do encryption?

I tried installing the same in another PC and it worked.So can i install sql server 2008 R2 RTM in a windows 8 pc? According to link (http://blogs.msdn.com/b/sqlexpress/archive/2012/03/02/sql-server-express-and-windows-8.aspx) it's not...

Hi nicbyte

Do you mean that install directory is corrupted or what?

Config file is properly configured for new installation.Setup path config file path and all parameters are proper. Also i have doubt that should i enable .net 3.5 to install sql...

hi nicbyte

I have config file and setup file in the same folder.

Does .net 2.0 is required only for installation of sql server 2005 express or does it used by sql server for it's working?

If i go to SQL Server Installation Center and click on Installation hyperlink and then on new installation.. then it asks for installation media.(from link http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/F6C35A03-B98C-46F1-8010-0A76DF8773D5)

Can i install new instance...

So should i run the setup again? Or is there any other method by which i can install new instance(named instance) by using already installed sql server.

No. I don't have any triggers in customer table.

Here is complete details on what problem i am facing

Problem with “ExecuteNonQuery’”:

We are using VB.Net & in the below code sample ‘ExecuteNonQuery’ method returns -1 while executing Insert & update...