hehe good! point sushila but I usually assume that to be a software architect you should be good. Apparently I am wrong

And they call themselves "Architects" ... Would they preffer dynamic SQL ?

You can still send the batch in one roundtrip but SP is...

The usual way is to create a function to concatenate the output and then

apply it to the source table. This is a lot better handled in the client side but if you...

Migel,

I have already adviced you against dynamically creating triggers on the flight on that same thread you posted above.

If you still insist I...

because you are using two distinct actions 'update' and 'insert' you will need to have separated statements at least until SQL Server implement Oracle UPSERT or IBM Merge

1. are you sure the DATA is the same?

2. Can you post the query ?

All I can say is what Scott already warn you about. You are the only one who can determine how much is going on on your system. You are the...

why would you use sp_execsql if calling the procedure directly will give you what you need:

exec @RetError = usp_myStoreProc @a, @b-2, @c out, @d out, @e out

I am pretty sure that there is a set based approach to solve your problem but I don't understad clearly what is the final outcome that you need. Based on...

if you don't or can't use triggers but can shed some $$ have a look at idera SQL Compliance Manager and if you...

use a trigger

This may shed some light

FAQ: Table variables

Try if at all possible not to call a web service from TSQL and it is even worse from a trigger!!

Just my $0.02

There are several way to do this, here goes one:

create table x

(

validation  char(10) not null,

validFrom datetime not null,

validTo datetime not null

)

create function dbo.IsRangeValid ( @s-2 datetime, @e datetime)

returns int

as

begin

declare...

Richard: Nice rant