Wohhh!!, nice setup .

I like some of m topes too .

Thanx for the backup.

You need to do 2 separate updates.

What's the problem with farrell's solution???

Look up derived tables in BOLs. It's basically another select that you name and reuse as a table in the select without the hassle...

Is he at least in the ddl_admin group?

Is the proc qualified with the owner in the script?

This trigger does more than auditing, but you'll get the idea :

CREATE TRIGGER [UpdateSommePiece_AuditEP] ON [dbo].[EMPLACEMENT Pièce]

FOR INSERT, UPDATE, DELETE

AS

SET NOCOUNT ON

Declare @iCountIns as int

Declare @iCountDel as...

Does he own the proc. Is he at least in the ddl_admin group? Is the proc qualified with the owner?

Well I did... once I got up from bed.

I'm sorry to say this, bu we don't know everything here... yet.

His solution to find out what the decimal separator was.

Maybe but it's still a good idea .

There's just no need for dynamic sql here ::

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions in T-SQL

August 24, 2005 at 7:13 am

#584569

You can also use this (unsupported by MS) :

EXEC SP_MSForEachDB 'Select ''?'' as DbName, count(*) as Total from ?.dbo.SysObjects'

A more advanced version of the top + group by ::

SELECT O.XType

, O.name

FROM dbo.SysObjects O

WHERE ID IN (SELECT TOP 90 PERCENT ID FROM dbo.SysObjects O2 WHERE O2.XType = O.XType order...

Here's an exemple of this technic :

SELECT O.XType

, O.name

FROM dbo.SysObjects O

WHERE ID IN (SELECT TOP 90 PERCENT ID FROM dbo.SysObjects O2 WHERE O2.XType = O.XType order by O2.Name)

ORDER BY...