The Application is Sproc/Read/Write Permissions.  It is a separate install that does the DB maintenance as DB_Owner.  That is safe.  I was thinking something similar as to what you are...

The Nolocks is how they want views written for reports so there are less page locks.  I guess they are not concerned about ghost reads.  We have not had adverse...

Thanks for the ideas.  Both isnull and Coelesce work.  I chose isnull, but really they both were fine.  thanks for the help

That is great work. It is exactly what I needed. Thanks

That is a tough setup to visualize. I feel your pain with guids, and trying to work with indexes. I have found from past experience that adding an...

Thanks guys for getting me resolved quickly. works well now. Triggers always mess with me. I would have thought that first statement would work. It passed...

I thought we were saying something like this would work

ALTER TRIGGER [dbo].[BadUpdate]

ON [dbo].[SomeTable]

INSTEAD OF UPDATE

AS

BEGIN

IF EXISTS (

SELECT 1 FROM dbo.Foo

...

OK so it is not a pass/fail. It is a Pass -> UPDATE SomeTable SET WHERE. That is what I was kind of thinking but wasn't sure. Thanks

I think I found the answer here:

http://www.sqlservercentral.com/Forums/Topic1044870-392-1.aspx

BEGIN TRY

BEGIN TRANSACTION;

-- Some code

COMMIT TRANSACTION;

END...

That's interesting I did not know you could do that. Are they trying to get away from doing select and unions?

INSERT INTO @Temp

SELECT * FROM (SELECT @QuantityID as ID UNION

SELECT @LengthID UNION

SELECT @CostID) Temp

WHERE id is not null

Better idea than this?

That is basically what I have.

SQL2008Dev

SQL2012Dev

SQL2014Dev

It is organized, but I have issues with my scripts. I have made an installer that runs scripts to build DBs for different regions....

I am in pretty much the same place. I have to verify each version and then if things happen in customer locations I have to get the DB's to...

I thought so....I was really hoping, but knew it was a long shot. Thanks for the quick reply

There is no problem with the code Steve presented. I just did not want the overhead of the select from a temp table. It seems like that will...