Viewing 15 posts - 496 through 510 (of 3,221 total)
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...
April 25, 2012 at 6:56 am
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...
April 24, 2012 at 9:44 pm
Thomas Abraham (4/24/2012)
bitbucket-25253 (4/24/2012)
April 24, 2012 at 6:11 am
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 ...
April 24, 2012 at 5:30 am
Post removed. See GilsaMonsters' following post ... as it IS CORRECT !
April 23, 2012 at 8:52 am
Duplicate posting. Please reply at
http://www.sqlservercentral.com/Forums/Topic1288206-145-1.aspx
April 23, 2012 at 8:26 am
You should read this blog posting:
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...
April 22, 2012 at 7:11 pm
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...
April 20, 2012 at 6:48 am
My apologies, but I do not understand your request. Could you provide a sample of the results you are looking for ?
April 20, 2012 at 6:37 am
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...
April 19, 2012 at 7:54 pm
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...
April 19, 2012 at 12:36 pm
1. In your maintaince plan step 3. Update statistics is unneccessary
since during the rebuild process the statistics are re-computer. See
2. In your maintainence plan do you determine...
April 18, 2012 at 8:12 am
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"
April 18, 2012 at 6:38 am
Viewing 15 posts - 496 through 510 (of 3,221 total)