My question would be "Why do you want to do this"?

If it is something that the front end application requires then I would return the original recordset but have the...

Yes

Provided your query uses Col A the index will be used.

CREATE PROC dbo.MonthReport
@YearOne CHAR(4) , -- I an assuming that Year is a 4 character string such as 1999
@CID VARCHAR(50) -- I am assuming that CID is the customer name.
...

It looks like the psuedo syntax out of a reporting tool.

Cognos queries sort-of look like SQL but aren't really.

I would not be nervous of the physical process but would be very nervous from the perspective of capacity.

I worked on a project where it was calculated that running 2...

Wrap your CASE statement in a CAST(CASE statement AS CHAR(3))

I have had problems with BIT fields doing peculiar things

I would try and use DTS but have three separate queries. The first would be

select

serverproperty ('servername') as 'Server' ,

ISNULL(serverproperty ('InstanceName'),'') AS 'Instance Name' ,

serverproperty ('edition') as 'Edition',

serverproperty ('productlevel')...

Firstly what are the datatypes of your three columns and why store a date as three columns when a SMALLDATETIME will do?

My approach would be to use the CONVERT statement...

Why not read a different thread then and leave us old farts to wallow in the rosy glow of nostalgia.

* * *

Of course no one is mentioning having to crimp...

The only reference that I could find was SQL Server 2000 High Availability Series Implementing Network Load Balancing

I always thought that clustering SQL servers was simply to provide resilience....

My first job involved an HP3000/42, 52 and model 70 mini-computer and the 300MB disk drives for that were about the size of a laundrette washing machine. I suspect...

Are you experiencing problems with the way you are doing things at present?

If not then I would take the view that if it isn't broke don't fix it.

I try and...

If your unique ID is your primary key or a unique index then SELECT XYZ FROM dbo.abc WHERE key='232' is going to be fast no matter how many records you...

No, there is no drive mapping involved. It is simply a case of writing to a local directory.

I have tried right-clicking on the scheduled job and adding my intended...

Jeff,

Have you seen the trick where you do a completely superfluous WHERE {ClusterIndex} BETWEEN {ClusterIndex}.MinValue AND {ClusterIndex}.MaxValue

In SQL2000 this can force the clustered index seek even though the clause does...