For the trailing spaces why not use the RTRIM function for example:

DECLARE @Area VARCHAR(50)

DECLARE @A2 VARCHAR(50)

SET @Area = 'GAUTENG EAST 1 '

SET @A2 = 'GAUTENG EAST 2...

Thanks Jeff, another great article with code that everyone should add to their sandbox DB. And of course, use same, to test if an item is ready for...

Thomas Abraham (4/24/2012)

---

bitbucket-25253 (4/24/2012)

---

... 2nd select returns 2147483646 yes the sequence is descending, but still not what is the supposed correct answer, so I am still confused and...

OK no longer confused or perplexed -

I am some what confused and perplexed for when I run

(in Denalli CTP3)

SELECT name, start_value FROM sys.sequences;

the return values are:

name ...

Post removed. See GilsaMonsters' following post ... as it IS CORRECT !

Duplicate posting. Please reply at

http://www.sqlservercentral.com/Forums/Topic1288206-145-1.aspx

You should read this blog posting:

http://blog.sqlauthority.com/2009/03/11/sql-server-difference-between-union-vs-union-all-optimal-performance-comparison/

Which contains:

A UNION statement effectively does a SELECT DISTINCT on the results set. If you know that all the records returned are unique from your...

Nice question ....

To help those who want to help you with a tested solution, please post table definition, sample data and required results when using the sample data.

You can do this easily...

My apologies, but I do not understand your request. Could you provide a sample of the results you are looking for ?

Is this what you are looking for?

CREATE TABLE #T(AName VARCHAR(10),ALevel INT)

INSERT INTO #T

SELECT 'Stefan',3 UNION ALL

SELECT 'Mike',2 UNION ALL

SELECT 'Samuel',4

SELECT AName,ALevel FROM #T -- check input

DECLARE @newlevel INT

DECLARE @oldlevel INT

SET...

Oops did not refresh to see your last post before I posted this.

In general something like this might just be useful, if you have NOT solved your problem.

CREATE TABLE...

1. In your maintaince plan step 3. Update statistics is unneccessary

since during the rebuild process the statistics are re-computer. See

http://decipherinfosys.wordpress.com/2008/02/07/index-rebuilding-vs-index-reorganizing-in-sql-server-2005/

2. In your maintainence plan do you determine...

Refer to:

http://msdn.microsoft.com/en-us/library/ms164086.aspx

For a full listing and expanded explanation of error messages.

Depending of what you mean by type it could be "System defined" / "User defined" or "Fatal" / "Non Fatal"