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...

Yelena: That's a typo from early documentation that hasn't been corrected everywhere.

Indexed views may be used in SQL 2000 Standard Edition by specifying the NOEXPAND index hint.  All editions allow...

Looks like you can dodge all the CASE statements With a NullIf(value, 2):

NullIf(Min(IsNull(CONVERT(smallint, PermissionField1), 2)), 2) AS NewPermissionField1,

Testing (in results,PermissionField1 should...

PIVOT works best when you are using aggregations (count(), sum() avg(), etc.).  In this case, because you want to return every value instead of the results of an aggregation over...

A really solid book is Ken England's Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook.  It's less than 400 pages, and packed with info.  It's one of those rare...

This sounds like a homework question...

Have you tried it?  What was the result and what would you like explained?

-Eddie

56,000 bytes. (call it ~100kB, depending on your fill factor)

If this hypothetical table were real, then you've already spent more of your company's/customer's money thinking about this than the cost of...

The trick that's helped me the most: just book the test.

Once I start getting comfortable with what will be on the test - but long before I'm ready - I'll register for...