"Scalable" to 50M records?  We're jamming 200M records every day into a couple SQL Server 2000 databases at my company. 

Here's the simple math:  If a company cannot afford a...

Just like VB6: set a reference to the SQL-DMO COM library.  COM-Interop will take care of the plumbing.  You may even be able to upgrade much of your VB6 project...

Try joining Inc_History just once without the condition, and use a CASE statement to separate the two types of values to sum:

To get the Incident_Bill time:

  CASE...

I've tried something similar in the past.  I don't recall my full experience, but I've got some ideas.  I think the key was using linkedserver.master.dbo.sp_executesql, and including a...

Jules,

  Common Table Expressions (CTEs) are new to SQL Server 2005, this might be a more lively thread over in one of the 2005 forums.

  From BOL:"A CTE is...

You forgot the Cell_Phone column in the temp table, between Office_Phone and Total_Contribute.

-Eddie

  IDENTITY_INSERT, as Sergiv pointed out, is quite useful, but only when you wish to disable the IDENTITY column temporarily.  Only one table may have IDENTITY_INSERT set to ON for a...

You don't need a license to execute BACKUP DATABASE.

First, is PayCode (in paymentTypes) a value that is unique per payment, or is it a way of determining what type if payment (cheque/cash/credit card) was applied?  If it is...

>Need a script to mess up the data in a table

Hmm... you could just install Enterprise Manager on developer computers and go to lunch.  They'll take care of it for you,...

Enter the lowly NULL value.

The credit card info columns in your target table(s) must allow null values...

CREATE TABLE dbo.PaymentInfo(

....(other columns)...

@cardName  nvarchar(50)          NULL,  

 @expirationDate  DateTime       NULL,

 @authorizationCode nvarchar(50) NULL,  -- nvarchar? do you get...

Take a look at SQL Server 2005 Reporting Services.  (I know you're running 2000, but the 2005 Reporting Service and its databases could be installed on a separate box, connecting...

If my usual search is going from top (parent) to bottom, then I cluster on the ParentID column, in this case, SupervisorID.  I usually have more than one column as...

> ...But its length is maximum upto 8,000 charaters

nvarchar(max) can hold over 1,000,000,000 Unicode (double-byte) characters.

If you're having trouble getting all of your data into the variable, be sure you're...

The scores were fixed a few weeks ago, the email went out recently (I got mine last night).

There were a *lot* of people (including me) who walked away from that...