To count sub-sets, use CASE to make your different tests.  For each test, the CASE should return 1 for true, and 0 for false.  Then you can just sum() the results,...

Could you post a little DDL and sample data to help us out?

Are you using SQL Server 2005?  One query does the trick:

-- Set up sample data
DECLARE @Source table (CostId  

In SQL2005, you could roll a UDT and include a column of that type in your table.

Under SQL2000, the only way to get both in a column is with a...

  In a Server + CAL environment, SQL Server does not keep count of CALs used.  Remember: a User CAL licenses a user for an unlimited number of connections, a...

Take a look at the master.dbo.syscacheobjects table.  This is a virtual table that will list every compiled plan in the cache for every database on the server.  Any currently-compiled procedure...

Time for some overkill with the new stuff   I mixed some XQuery with an UNPIVOT

-- Prep the sample data
DECLARE...

  The 'check existing' setting on constraint creation is not stored anywhere, afaik.  Once you create the constraint, there's no need to track the value.   

  You can determine the...

SET

NOEXEC ON

GO

Insert that at the top of your script and execute it.  It will...

> http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/

It's seriously exciting, provided your organization is willing to drop $5,500 per developer/architect/tester/db pro for any single VS Team Edition (architect, developer, or tester; DB pro should be...

What are you using now?  If you've never taken any certification exams, then your first one should be on material with which you are most comfortable.

The 2005 certification exams cover...

For an effective source control solution, it helps to go through and uninstall Enterprise Manager from anyone who will be touching your systems.  Otherwise, you get folks who use it...

Have you tried loading up a SqlTypes.SqlXml variable with your document and passing that as a parameter to a stored procedure? 

The procedure:

CREATE PROC...

I see you're using the templates.  Note that they are just samples, and there's plenty of room for you to modify them for your needs.  This stored procedure template sets...

Red Gate's SQL Data Compare can reduce that pain:

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

(If you buy, tell them an MCT sent you )

As for any aspiring developers reading...