Category Archives: Programming

Counting Trailing Spaces in SQL Server T-SQL

I recently had an issue with some data grouping in a third party application where data that appeared to be the same, was being grouped separately. E.G. Example Data: AB AB AB BC BC BC BC BC BC DC When … Continue reading

Posted in Programming | Tagged , , , | 3 Comments

SQL Filters with Optional Parameters

Lets say, for example, you have some information on Cars that you want to filter buy either make, model, colour, or any combination of these.  I.e. if you select red cars you will get all makes and models that are … Continue reading

Posted in Programming | Tagged , , , , , | Leave a comment

SSIS Lookup Component Error: output column ‘x’ and reference column named ‘y’ have incompatible data types.

This error was driving me mad for ages, I assumed that the data types were in fact different!   Silly me.   This error is caused by changing the data type(s) of one (or more) of the underlying columns referenced by the lookup component. … Continue reading

Posted in Programming | 2 Comments

Newline in C# – rn ?

Coming originally from a VB background I was perfectly content using vbCrLf to add newlines to my strings.  Unable to find a C# equivalent, all my early C# code was scattered with ‘rn’ as a suitable replacement.   Works well, … Continue reading

Posted in Programming | Leave a comment

Newline in C# – \r\n ?

Coming originally from a VB background I was perfectly content using vbCrLf to add newlines to my strings.  Unable to find a C# equivalent, all my early C# code was scattered with ‘\r\n’ as a suitable replacement.   Works well, … Continue reading

Posted in Programming | Leave a comment

SSIS Custom Transformation Component

We have a data migration routine that is currently a set of stored procedures that pulls data from multiple databases and consolidates it in one database for reporting purposes.  My newest task… move this into SSIS.   One of the … Continue reading

Posted in Programming | Leave a comment