You could also use Sort transform on the employees path, sort by manager_id and remove duplicates I think.

Regards

Piotr

You might also look at the SSIS, once you get the grip of it, it is pretty flexible.

Regards

Piotr

You write SET only once in update clause:

WITH UpdateAverageLabourCost (ProductId,OH,Labour) AS

(

SELECT

AC.ProductId,

AC.OH,

AC.AVGDirectLabour + MAN + SUB - OH AS Labour

FROM dbo.AVGCost AC

INNER JOIN dbo.Products p ON AC.ProductId = p.CrossReference

WHERE Type...

To prevent users from being able to read schema information you have to deny view definition right.

There are several ways you could organize it, depending on your needs. One of...

I'd have a look what transactions and which databases the version store is generated for. It might give me clue regarding what process may be responsible for the issue.

But I...

Have you tried to select from sys.dm_tran_version_store?

Regards

Piotr

Now, that's a cunning trick I see now Jeff :w00t:

Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations sorted out'.

And now I...

Hi Rajg,

I can't find the definition of the IX_VarOffice index in code you sent. Also as Gail said it would be helpful to see create table statements and the definition...

It does unfortunately..

set language us_english

go

select @@datefirst, datepart(dw, getdate())

go

set language british

go

select @@datefirst, datepart(dw, getdate())

I had to cope with this on a few occasions.

Piotr

+ 2 bytes to store the length of data;)

P.

Very interesting. I found out that if you change data type to nvarchar or use newer collation like Latin1_General_CI_AS, everything works OK.

The BOL says in Using Binary Collations: "Older SQL...

Hi Kevin,

Look at the OUTPUT clause in books on line.

Regards

Piotr

Cursors are evil, aren't they? 😎

Here's a solution that seems to work without cursors and CLR.

create table TableA(itemid int identity(1, 1), itemname sysname)

go

set rowcount 500

--populate tableA. if you need more...

Hm, I imagine that such alter of table updates all the rows in it - according to BOL the Sch-M is acquired. There is a remark that "Changes that...

I don't think you can return a data reader from a pack. You could probably store the merge output in an ADO dataset and store it in variable which you...