Sounds like you need an intro to SQL... here's a good overview...

http://www.sql-tutorial.net/

 SELECT MIN(fName),Age

   FROM yourtable

  GROUP BY Age

Although not sure why you want to give the alphabetically earlier names such a break.  Why do you need to do this?

Outage = perception

... or ...

Outage = contract stipulations

On the perception side, if you can't do your job because some system is down, I'd consider that an outage.

I won't get into...

Please post the query that you've tried, so far... I'm thinking all we need to do is change one of the joins to an outer join and use ISNULL(columnname,0) on...

PCQ,

It's kinda like asking us to fix your car without seeing the car.  Please post the offending code and table structure along with maybe some sample data

I guess BOL doesn't have a really simple explanation of what an INDEX SEEK is nor why it's better than an INDEX SCAN...

Basically, the name of each says it all......

http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdf

But this is an example of what I'm talking about... this was first on the returns for Google when I searched for "CHART OF SYSTEM TABLES FOR SQL SERVER". ...

This is one place where a "control loop" will help... write the code to only update a couple million at a time in a loop until everything has been updated.  You'll be...

This is a great advantage in parameter use...

Why?  Why do you need to pass a table as a...

Yes... that will work but it's not "dynamic" like the Op asked... if the length is a variable, it will not display as expected in the Text Pane.

This is where you ask "What is Books Online"?

"Books Online" is affectionately known simply as "BOL".  In SQL Server 2000, you can find...

I'm thinking that probably won't matter on BCP that uses "QueryOut"

Thanks Carl...

... or... create a partioned view...