Kirt,

Can you DELETE duplicate rows once they are INSERTED:  YES,

Can you also set-up PRIMARY KEY to IGNORE DUPLICATE:  YES

Question:  IF you can ID them as DUPLICATE and NOT...

If Windows 2K then you will need physical CPU's, W2K doesn't really use "virtual CPU's" properly.  IF Windows 2K3 then "Virtual CPU's" will work just fine.  Just went through this...

Why not have the SP on all the different servers that may get called.  THEN set-up your different connections inside your WEB application and call the proper connection for whichever...

To add to what Frank has written try

SELECT CASE CONVERT(VARCHAR(10), GETDATE(), 101)

  WHEN '05/30/2005' THEN 'Happy Memorial Day (US)'

  WHEN '07/04/2005' THEN 'Happy Fourth of July (US)'

  ELSE CONVERT(VARCHAR(10),...

I think that the replies here are for HOW to query a different server and the original question was HOWTO install code on MULTIPLE servers.  I still think that my...

In addition to Remi code I would ensure that either one of the below (or both are performed)

1.  Make sure that the CursorLocation is set to be ADUseClient either RecordSet...

Have you made sure that the Developers environment is the same as the other environment? i.e:

#records same

Table schema are the same (indexes, etc...)

I don't know of anyway to FORCE the system...

Please check and ensure that the table has a PRIMARY KEY.  Most of the time this is the problem

PS.  You will need to...

M,

I think if you please re-read Remi's post the problem is you are not telling SQL how the 2 tables relate to each other Diaryentry, workrequest

What you...

I am currently doing the same thing...  DIVIDE milliseconds by 1000 Please note you need to CAST or CONVERT the milliseconds side to DECIMAL or NUMERIC LIKE NUMERIC|DECIMAL (18, 4)...

Zineb,

What language are you using to code with?  That will help us figure this out with you.

Try

'%'+villaName+'%' + instead....

I would have ALL users added to a Windows group.  GRANT permissions to that GROUP inside of SQL.  This way you have to maintain a SMALL number of changes vs....

Short answer (based on complexity) you can't.  Why not use tried and true methods such as OSQL i.e (inside a BAT file)

SET ChangeRecord=ABC123

SET LOGDIR="C:\Temp\%ChangeRecord%"

IF NOT EXIST %LOGDIR% MKDIR %LOGDIR%

SET LOG=%LOGDIR%\ProdInstall_%ChangeRecord%_runsql.log

SET...

INNER JOIN is the explicit version of JOIN.  By DEFAULT if no join type is given SQL says INNER JOIN...