Aaron Bertrand, thanks to the heads up 🙂
March 2013 Cumulative Updates – SQL Server 2012 SP1 & 2008 SP3
Cumulative update package 3 for SQL Server 2012 Service Pack 1
Cumulative update package 10 for SQL Server 2008 Service Pack 3
SQL Server 2012 Service Pack 1 Cumulative Update #3
Build # 11.0.3349
KB Article: KB #2812412
Relevant for builds 11.0.3000 -> 11.0.3348
NOT for SQL Server 2012 RTM (11.0.2100 -> 11.0.2999)
SQL Server 2008 Service Pack 3 Cumulative Update #10
Build # 10.00.5835
KB Article: KB #2814783
Relevant for builds 10.00.5500 -> 10.00.5834
NOT for SQL Server 2008 R2 (10.50.xxxx)
I’ve found this great example of an interactive PowerPivot worksheet by Robert Mundigl about the beer prices at Munich’s Oktoberfest.
How it works?
Actually it’s about the same technic as Kay Unkroth used earlier in one of my previous posts.
Well…here’s how Robert did it!:
Have a look at Robert Mundigl‘s blogpost and his tutorial: Click here.
The example is also downloadable via this URL.
Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:
It’s easy! 😀
DECLARE @String NVARCHAR(MAX)
SET @String = N''
--How to easily check whether a @String contains Unicode characters or not (like Japanse characters) - simple method:
IF CAST(@String AS VARCHAR(MAX)) != @String
--String contains unicode character(s).
--String does not contain unicode character(s).
I was looking for an easy to use function (udf) in SQL to convert any text to ‘Proper Case’ (also known as ‘Title Case’) and found Pinal’s blogpost:
Except, it wasn’t working properly for S’s or unicode strings…so I’ve added a few lines of code and here’s the result:
IMPORTANT: This UDF wasn’t build for performance, use it with care.
In my scenarios, I used it in my ETL processes just before inserting/updating the deltas/changes and thus minimizing the performance impact.
You’ve be able to download the T-SQL code here (just copy&paste the code into SSMS):
TextToProperCase – Unicode proof