blog community
Sign in
|
Join
|
Help
Home
Blogs
Media
Mark Streutker
»
All Tags
»
SQL
(
RSS
)
Browse by Tags
Mark Streutker
Home
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Handling EAV-data: Timelines
Is ISNUMERIC numeric?
Handling EAV-data
Tags
EAV
Functions
PIVOT
SQL
View more
Archives
February 2010 (1)
October 2009 (1)
June 2009 (1)
EAV
Functions
PIVOT
Handling EAV-data: Timelines
As promised in my previous post about working with EAV-data this post would about handling multiple timelines (or periods for that matter). While this blog is specifically written for an EAV-environment, the technique explained in this post can be useful...
Published
22-02-2010 19:29
by
marks
Filed under:
SQL
,
EAV
,
PIVOT
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:
SQL
,
Functions
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...
Published
01-06-2009 18:38
by
marks
Filed under:
SQL
,
EAV
,
PIVOT