SELECT COUNT(case when Trans_Date >= '04/01/2007' AND Trans_Date = '05/01/2007' AND Trans_Date < '06/01/2007' then ID_col else NULL end) as [05/07],

....

What's the size of recordset returned in QA?

Where it goes when you run query from osql?

Yes, you can.

If you don't plan to have more than couple of hundreds records in this table.

You you expect the tabe to grow you need to fix table design and...

1st, date must be stored in database in datetime datatype. No format involved.

2nd, open BOL and type in "Index" keyword CAST, press Enter twice and read about converting strings to...

Run

exec master..xp_fixeddrives

What is the result?

SELECT slNo, Name, Description

FROM dbo.MyTable

GROUP BY slNo, Name, Description

HAVING COUNT(*) = 1

Can you run the same command from QA?

> I just created a workbook with over 1500 worksheets.

Good revenge!

ChrisMoix,

how do you know that item transferred from 7 to 8 is the same item transferred from 5 to 7?

How you gonna distinguish 2 deliveries from 7 to 8 happened...

Sounds like "Whatever"

Do you have any idea what kind of resultset you're trying to retrieve?

Can you explain it in plain English?

Problem with this you MUST know the name of the sheet inside of Excel Workbook.

And users use to rename/delete those sheets without asking permissions from those bloody developers.

INDEX SCAN will be used every time you query for a range of values from a column not having clustered index on it.

BETWEEN means CLUSTERED INDEX.

End of story.

Still being rebuilt?

Don't include queries to system tables into procedures called by regular users.

It's not allowed in every environment.

Check BOL for "system functions", "security functions"

select suser_sname(), CURRENT_USER, system_user, host_name(), etc.

will give...

Clustered index must be on logWritten column.

And use join anyway.