Job y must be pretty important if it's worth trashing a backup for!  Have you done any investigation into why your backup sometimes takes 30 minutes and sometimes 2 hours? ...

Pavan

This page from Books Online should get you started:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm

I'm a bit concerned, though, that if the user who creates the procedure doesn't have access to the objects in the stored...

You've posted in the SQL 2005 forum... please confirm that you are using SQL Server 2005.

Thanks

John

What does job x do?  Bear in mind that if you want it to stop, you will probably want it to roll back as well... which could easily take longer...

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