David

Create a junction table that references the cases and the business units tables:

tblBUCap

---------

capID

buID

IsPrimary

John

Anchelin

I would recommend reviewing your database design and normalising it if possible.  If that isn't an option, the PIVOT function is described in Books Online:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/36b19e68-94f6-4539-aeb1-79f5312e4263.htm

I've never used it myself, but...

Apologies.  I started typing my reply before you added that requirement.

Slightly more long-winded than the original, but it seems to work:

DECLARE @i int

select @i = count(*)

from orders

where CustomerID = 'VINET' and EmployeeID = 10

group by customerid

SELECT COALESCE(@i, 0)...

Anchelin

Two questions:

(1) Have you read about the PIVOT function?

(2) You say that you have the "resultset" that you gave, but is that the result of a query other than SELECT...

I applaud the author's efforts to write in a language that isn't his mother tongue.  It's come out far more clearly than I would have managed had I been attempting...

You need to purchase licences for as many processors as the operating system has access to.  So one option is to disable one or more processors in the BIOS.

John

Did you try what the error message suggested?  What happens if you try to map a drive on the import machine to \\EXPORT\admin$, where EXPORT is the name of...

Charles

(1) The user list is defined by the DBA by adding all Windows users and groups that need access to resources on the SQL Server as logins in SQL Server. ...

Deb

Can't you just count the extents and multiply by 8?  I take it it's only an approximation you're after?

John

Mick

Books Online tells you the names of the columns.  They're TABLE_NAME and COLUMN_NAME.

John

Deb

You don't say what version of SQL Server you're using, but if it's 2005, have you tried the dynamic management views?  They begin with sys.dm_ and they have a lots...

You could have your transaction log just truncated and not backed up while the optimization job is running.  Then, when it is finished, take a full backup of the database...

--Table

CREATE TABLE LineNums (INVOICE int, linenum int