Thanks Igor.

So according to your suggestion, the index would be:

After creating this index, how can I determine whether it is performing well or not?

What if I create two indexes as below:

With MERGE I want to know whether I can do something like this:

MERGE <table name> USING <sql>

WHEN MATCHED THEN

IF (condition) Then (Update Query)

When NOT Matched...

Ok, so I see those books on SQL Server 2008. Since 2012 is there, shall I wait for these books to get revised for 2012?

I need to check the availability of those books in India. Does that book on administration include Architecture and other Internals?

Any web resources?

I am struggling to create a sample data for you.

I guess you missed my second post above where I added complete code with COUNT and image as attachment.

Data is not possible for me, but I am attaching output that I am getting when below given query is used:

SELECT district_nm,Count(urban_appr) as urban_appr, Count(urban_inprogress) as urban_in, NULL, NULL, NULL,...

I want to download SQL Server 2008 Express R2 with Advanced Services. Where I can find the .iso for this edition?

I also got similar error. Later I changed it to 11433. (see below).

=============================================================

Dim Constring As String = "workstation id=MYLAPTOP;packet size=4096;user id=rpk;password=123456;data source=62.141.48.155,11433;persist security info=False;initial catalog=testdb1"

Thanks for the replies. But I got the reply from the Microsoft Community and they gave the following link:

http://support.microsoft.com/?id=247750

Go to this link to know more about the double quotes problem....

Thanks Andy,

I will try your method, and come back to u.

Thanks a lot.

"Here is a test to find out whether your mission in life is complete. If you're alive,...

Andy,

Since I am new to SQL Server 2000, I am not following the row level method. Please decribe it how it can be done. If I create a new user...