True, Delete syntax is ugly whe using From

Delete C

From

      PARTY_COMMENT C JOIN PARTY P ON C.PARTY_ID=P.PARTY_ID

<A href="mailto.CORRESPONDENCE_ID=@corrid"> 

and then another one for Phone

And...

Mike if you follow the all code in one shot don't need to start 3 separated transactions just wrap them all in ONE! -- it will make your life a...

Scott, Think PREEMTIVE MULTITASKING!

when your procedure is running others can be too!!! scope_identity is one vaiable per session, @@identity is one GLOBAL thing, if another procedure inserts a record on...

How are you looking at the results? QA

if yes check the tools->options->result tab and check the max char length

In data adquisition systems (SCADAS) the sampling period can be used to "filter" the noise of slowly moving variables like temperature. You usually do not have the luxury of a...

I can give you plenty within the realm of Control systems but out side of it I am not sure

It would have been cooler if you use the Hex or maybe binary representation

Many statistics in Control systems applications are heavily based on the sampling period and it make sense a lot for simulation purposes also!

You are very swift too    so shouldn't complain around here

>> Create the view WITH SCHEMABINDING

That way the tables (or other views) referenced by the view cannot be modified in any way unless the view is dropped first....

May I ask why do you say that you can't join a table to a view? obviously from the above post you see an example on how to do it. Are...

Did any of this test Evaluated CPU utilization on the server?

I see a lot of round trip timings but not what is going on on the server which is...

EXACTLY!

The real advantage of the RPC is the ability to reuse parametrized plans.

I would like you to create the parameter once and CHANGE the parameter value on each iteration...

Sorry for my delay in the reply.

Well I think that data is still not realistic. Can you post how did you performed the Loops ?

That was not what you posted a couple of posts ago

>> I'm not the president of the company, yet