Did you consider Merge replication?

Both "Case" and "Or"  are attractive to developpers.  But I know that in Production they give trouble.  My intention is not to prohibit the use of OR (or case) in where clause. ...

Read the first comment by Joe Nakanishi 

What do you want to insert when only one condition is satisfied?

If you dont want to insert that row, place what in the where clause.

Hope this is more clear

You can try with sp_ExecuteSql:

DECLARE @sql nvarchar(4000),  @val money

   SELECT @sql = 'select @val=(329.02 * 1.2) * 1.20'

   EXEC sp_executesql @sql, N'@Val money OUTPUT', @val OUTPUT

   SELECT...

If you use (@READONLY=1 or PublishOnIntra = 1) in the where clause, that clause may not be SARGable.  But however,  it depeneds on the statistics and you can never be sure. ...

Even though you can do something like this to accomplish in one statement, it is not cost effective

WHERE StoryStatus = 4 AND MediaNewsReleaseDate <= GetDate() AND Project = @ProjectID AND...

Do you want to insert a default value instead of NULL then add ELSE <DefaultValue>  at the end of your case statement (before end) 

If you want to limit the...

The reason for the second select statement is we dont have an output parameter. when you have a parameter, it will return only one value.  In multiple inserts, you may...

On Update you will have a problem if the user wants to update soem other column. (without changing the username)

The best option is to use an Unique key on username. ...

I suggest that you should add the COid of all instances of ClientOffice in the select statement and keep in the page (May be hidden). Then you can update each...

I just saw the reference of User_ID in the code.

The post before will work.

Hi Raj,

I am not sure of the logic for User_ID.  However,  If you are using variables to insert into a table you can insert only one row. 

Assuming that @ID...

Based on SQL-92 standards, null is not equal to null. (As null means, not defined or unknown) However, SQL Server offers another feature to turn off this option by issueing...

Can you add another file into the same filegroup.

I have installed sp4 almost immediately after installation, and I dont have any issues like this.

BTW,  do u have full access rights...