LEFT equivalent in SSIS Derived Column Task
This command is the equivalent of the LEFT() function (cumbersome but effective)
2011-11-29 (first published: 2011-11-14)
841 reads
Derived Column
Dynamically Map Column Data Based on Column Pattern Profiling
Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.
2010-02-23
3,024 reads
2003-09-03
RE: Find second highest
quote: ...but SQL Server doesn't like it... I know. Annoying, isn't it, that you can't use a variable in the TOP clause...you have to use sp_executesql: DECLARE @n INT DECALRE @sql NVARCHAR(2000) SET @n = 76 SET @sql = N'select top 1 salary from (select top ' + @n + ' employeeId from employee order […]
2003-07-08
Blogs
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
The Only Valid Test of a Backup is a Restore
Please, let me reiterate: The only valid test of a backup is a restore....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers