|
A well-meaning person gives you a .nrg file and you will not invest in a piece of expensive bespoke software to read it. After all, you run free, open-source software and never have and never will pay for software. What to do with this stupid .nrg file? |
|
Read more...
|
|
|
String-Matching help for SQL Server |
|
The task of matching strings between heterogeneous systems, especially that of matching personal or company names or addresses, is not easy with SQL Server's limited set of built-in string SQL functions. Here is a C# CLR-Assembly (with source code) for SQL Server with some advanced string-handling functions that may help: -
LTrim - like Oracle's LTRIM function. -
InitCap - like Oracle's INITCAP function -
FlattenCharSet - Replace western characters with diacritics with best-choice, non-diacritic characters -
StripPunctuationMarks - Remove all punctiation marks from the given string.
Example: SELECT dbo.StripPunctuationMarks('Pharma A.G. (CH)') PharmaAGCH The CLR Assembly is written in C# in Visual Studio 2008 and works on SQL Server 2005 and SQL Server 2008 and you can download it here . Included is a pre-build assembly, SSISUtils.dll. |
|
Read more...
|
|
Why is there no English phrase for "Bon Appétit"?This was explained to me by a French colleague: Because the British cuisine is so woefull. |
|
|
|
<< Start < Prev 1 2 3 4 5 Next > End >>
|
| Results 1 - 4 of 17 |
