Category Archives: Programming

How to generate the alphabet from ASCII codes in T-SQL

Posted on 19/02/2014 by Jens Vestergaard

Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet. In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Subtle differences in Teradata and SQL Server, Part 2

Posted on 17/02/2014 by Jens Vestergaard

Implementing Business logic in views is something seen quite often. Actually a view in my experience often contains some sort of data enrichment, -enhancement or -extension. So I am surely not the first one to come across the thought of … Continue reading →

Posted in Programming | Tagged , | Leave a comment

Subtle differences in Teradata and SQL Server

Posted on 11/02/2014 by Jens Vestergaard

Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

Selected to speak at #SQLSat275

Posted on 04/02/2014 by Jens Vestergaard

If you haven’t already heard about the concept of SQL Saturday, I suggest you rush of to www.sqlsaturday.com and dive into the numerous opportunities to attend free Microsoft SQL Server training sessions. One such SQL Saturday is comming to Copenhagen, … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

How to do a String REPLACE in Teradata

Posted on 04/02/2014 by Jens Vestergaard

String Replace does not exist but can be accomplished with the following procedure: INSTALL REQUIREMENTS:– 1) GRANT ALL ON “%TDUser%” TO “%TDUser%” WITH GRANT OPTION 2) C++ compiler, if running the TD Demo How to replace “old” with “new” so … Continue reading →

Posted in Programming | Tagged , | Leave a comment