Here's another solution which does not involve CASE statement:
WITH
 IDs AS(
  SELECT DISTINCT
   ID
  FROM
   ValueTracking),
 Src AS(
  SELECT
   ID,
   CAST(REPLACE(Month, '_', '') + '01' AS date)...

Thanks a lot! I have a script, but I thought it's possible to do it with Send Mail task only.

Or you can create a custom format using yy or yyyy for year; M, MM, MMM, or MMMM for month; and d or dd for day. Note, that M's should be capital. For example,...

Thanks

Thanks to all of you for the info.

You have to make the 4 diffrent datasets. This is the only way. I'm even not sure that Custom Data Extensions will help you

Set Format property to HH:mm. make sure that the datatype of this value is datetime. Hope it helps.

Any arithmetic operation with NULL returns NULL.

SELECT fld1/fld2 will cause an error if fld2 = 0

SELECT fld1/NULLIF(fld2, 0) return NULL if fld2 = 0

You also can use NULLIF(fld, 0) in divider

Luiz,

RowNumber function doesn't work with matrices because it returns row number in dataset, not in matrix.

Here's what I did to alternate colors in matrix rows.

1. I've created a function

   Public...

Jules,

Cube is not updated automatically when underlying data changes. You do need to reporcess the cube to reflect changes

SELECT * FROM Region WHERE RegionDescription LIKE COALESCE('%East%', RTRIM(RegionDescription))

fixes the problem

In 2005 it works correct

Unfortunately, there's nothing like a checkbox or property that says: "Do not send if result set is empty". But you can create this subscribtion for your business users. You can set...

I had the same problem and didn't find standard solution. Every time thre was different solution and it took a lot of time to find it. Here's my approach to find...