Eugene Elutin (4/26/2012)

---

I agree that Service Broker would allow you to call procs asynchronously from within a proc. However, personally, if I would have the same needs, I would do...

If you are grtting this error:

The error I get is actually -

Invalid length parameter passed to the substring function.

It means some of your data does not contain the value...

If you reread Gus's post he broke out the Addr, CHARINDEX, and LEFT processes as a demonstration of each of the pieces.

Gus's code didn't work for me in SQL Server 2005, this is what I ended up running:

SELECT Addr,

CHARINDEX(CHAR(10), Addr, 1),

...

QUESTION: why SCOPE_IDENTITY() was used? Is it because:

1. both tables have a same column name named person_id alone (I mean ONLY just the name matters)?

2. person_id column in PERSON table...

Not from what you have posted. Not really sure what you are asking or trying to accomplish.

You may benefit from reading the first article I reference below in my...

Seems like a lot of work to setup OA Automation when SQL Server and Service Broker already have a lot of the plumbing already in place. I guess it...

Steve, How far out do you have QotD planned? I have been trying to get...

SQLKnowItAll (4/26/2012)

---

FunkyDexter (4/26/2012)

---

I apologise, Lynn, but my inner pedant insists on butting in here.

The first column of your table is an integer field defined with the Identity property. You have...

I haven't used it in an application, but I have used it...

Nope. Proc1 will wait until procB returns to proc1. The calls are syncronous.

If you are looking at implementing asyncronous processing you should look into using Service Broker.

The bottom line is this, you can't use dynamic sql in a function. Your choices are to have...

I will give you some ideas:

Be sure you understand indexes and the differences between them (specifically clustered and nonclustered, but not limited to just these).

Understand normalization and denormalization, the why's...

dwain.c (4/26/2012)

---

I love this thread! Just found it and have a way to go in reading it all though. All these people grousing about other posters not giving...

Well, good luck. I'd push to store the data as nvarchar instead of trying convert the data back and forth between unicode and extended ascii character codes.