Not sure what this would do performance wise, but it works without affecting double spaces inside of a string.

DECLARE @Area VARCHAR(50);

DECLARE @A2 VARCHAR(50);

SET @Area = 'GAUTENG EAST 1 ';

SET @A2...

Good catch....

First, I would say that you should have to separate stored procedures called by a master stored procedure depending on how you want the data sorted.

With that, I do have...

Please show me the code you used for both.

Try one the following (or both):

First prior to the update, SET DATEFORMAT mdy;

Or make the following changes to your code:

REPLACE( '2010-'+RIGHT(LEFT(convert(VARCHAR(50),service_date,121),10),5),'-','')

REPLACE('2011-'+RIGHT(LEFT(convert(VARCHAR(50),service_date,121),10),5),'-','')

Please read the second article I have referenced below in my signature block. It will show you what you need to post and how to post it in order...

There are uses for cursors. Determining when has to happen on a case by case basis. There is no general rule as to when you use them and...

Are the structures for the...

When you say different tables, are you saying each customer has different tables even withing the same database?

If every customer has their own database, duplicate all functions and stored procedures in each database and let the front end handle the connectionto the correct database depending on customer.

How many records in the source table?

Hate to say this, but this insert is marred by a ton of rbar code. The highly extensive use of scalar functions is...

How about these:

DECLARE @tststr VARCHAR(64);

SET @tststr = '\Beverages\Soda Pop\Mountain Dew';

SELECT SUBSTRING(RIGHT(@tststr,DATALENGTH(@tststr) - 1),1,PATINDEX('%\%',RIGHT(@tststr,DATALENGTH(@tststr) - 1)) - 1);

SELECT CASE WHEN PATINDEX('%_\%',@tststr) > 0 THEN SUBSTRING(@tststr,PATINDEX('%_\%',@tststr) + 1,DATALENGTH(@tststr) - PATINDEX('%_\%',@tststr) + 1)...

I have an idea, let's make all drugs illegal. I'm sorry, I watch TV and some of the side-effects of some drugs are worse than the disease they are...

TravisDBA (4/24/2012)

---

jfogel (4/24/2012)

---

What evidence? A post on the Internet?

If it isn't proven I'll go ahead and disregard it. My Wife's uncle died as a result of Parkinson's Disease a few...

May I ask we you need to do this?