Hi

Please clarify, you want to return digits "1 year" or "one year"?

Beside of question above ,small example:

SELECT name,

CAST(DATEDIFF(yy, create_date, GETDATE()) AS NVARCHAR(4)) + ' years, ' +...

I knew that WORK keyword is optional, but it seemed too easy,

thanks Steve.

Hi

Small tip, You can set the Interactive Height property of the report equal 0 to fit it on one page.

Best regards,

Mike

Hi

Imho You have to set the FailPackageOnFailure property to True on the objects (containers,task) in

your package upon which the checkpoints will be defined.

Best regards,

Mike

Hi

SCD type 2 is works well if the table is not too large and the changes doesn't happen frequently. But when the lot of changes happen in the attributes of...

Hi Abhijit

What is dateformat set on your server?

I 've got YYYY-MM-DD for example, so I simply do some setps:

1. Set up DT_STR, 26 as data type for column in...

A cool trivia question,

thanks Steve.

Forgive me, please replace line

WITH latest AS (SELECT ROW_NUMBER() over(PARTITION BY product_code, ORDER BY date_price DESC) AS RowNumber,product_key ,price

with code

WITH latest AS (SELECT ROW_NUMBER() over(PARTITION BY product_code, ORDER BY...

Hi Sjorsd

Please try with cte:

WITH latest AS (SELECT ROW_NUMBER() over(PARTITION BY product_code, ORDER BY date_price DESC) AS RowNumber,product_key ,price

...

Hi

If I clearly understand, you want to insert only the latest price from dbo.product, don't you?

Best regards,

Mike

Hi Ricardo

If you simply want to end the task with failure, you can do this in this way:

Public Sub Main()

'Dim Sum...

Hi

The trip down memory lane, I worked with Btrieve\Pervasive databases over a decade.:hehe:

Here are a few ways achieve it, please check if ddf files (data definition files) exist first.

If true,...

Hi

It looks as two or more data flow tasks try to read data from one source at the same time.

Best regards,

Mike

Hi

If job has a few steps to do, the last_executed_step_date will be not null for already finished.

Br.

Mike

I thought that the question is from the series of good practice, not about the syntax.

Best regards,

Mike