blog community

Mark Streutker

  • Is ISNUMERIC numeric?

    In SQL, if you’re not sure if a value can be cast to a certain datatype there are some built-in functions that can help you out. Take the following construction, where col_Value is a CHAR(4): 1: SELECT CASE ISNUMERIC (col_Value) 2: WHEN 1 THEN CAST...
    Published 30-10-2009 20:14 by marks
    Filed under: ,
  • Handling EAV-data

    In my line of work I often have to develop reports on all kinds of environments, but most of the time the underlying databases are limited to relational or dimensional models. A few months ago, however, I was faced with the tedious task challenge to build...
    Published 01-06-2009 18:38 by marks
    Filed under: , ,
Powered by Community Server (Commercial Edition), by Telligent Systems