I couldn’t get my assignment done without your help. Thank you.

This is what I want and it is really smart. One more help needed here, if in the table I have one more column Gender, can I get something like...

I am sorry for not providing detail information, I was on a rush on Friday. But just as all of you assumed, there are CustomerID, checkin (Date), checkout(date), and roomNumber....

I should not use NOT IN in the query. Either IN or NOT IN hurts the performance really bad.

Thanks for all your reply.

Using count(*) makes no difference.

I will try the index.

Here is the detail:

Query:SELECT count(ICS_ID) FROM dbo.Tl_ProgramDetail WHERE FunddateID not in (SELECT funddateID from dbo.t_FundingDates)

Table: Tl_ProgramDetail ics_id, pk, int not null

CenterID, fk, int not null

ProgramID, fk,int not null

PDate, datetime,null

Hours,...

It is a simple query SELECT count(ics_id) FROM

95% sure. Month, quarter and year Reports request the same thing with different range of data. I will capture a overnight batch process with a four hours limit. I...

Thanks for the reply.

Then shall I keep all the existing index when I am doing index tuning table by table? Or let the tuning wizard drop the index it...

Mine is in the query analyzer. It is the problem of the settings. thanks.:)

I have a similar problem. The column length for cIDs was set as nvarchar 700, and when I run query below, the value in the cIDs got truncated to

1,3,4,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,65,66,67,68,69,70,71,72,73,74,77,126,127,128,137,138,139,141,142,143,144,145,146,147,1

I...