bacon

This is a very useful method to learn

I also use this to check for PK violations when transforming staging records into live data

Could you create a cte for this and...

There's also a synchronous setting

Been caught out by this before where I was left wondering why it kept responding immediately

Interesting question and just so happened to have read about this last week!

That's why I always use parenthesis

They also make queries easier to read

Especially with +, -, *, /, ......

Learnt something new, thanks

Missed the 2016 part and compared to 12

Oh well, learnt something new

Makes sense j DBA

Meant to say went for 1!

knew the answer but can't ever recall using it!

Like this function and its offset approach

Well that's a new one on me...

Expected 1 and 2 ; went for 2 so guessed wrong

Now run this through, as with others, both 1 and 2 fail

Can't see this been SQL version specific or down...

Any thoughts?

This is getting seriously frustrating as I've never had issues before

Within a project, I have one package that works fine and will break wherever requested

I have another package that...

Fair point regarding the count method, Phil; and thanks for the code, Luis

Switched to the more efficient method and works

Thanks

Finally working

Thom A, misunderstood your example part

Set the expression of the variable to

"SELECT COUNT(*) AS recordCountDestination FROM " + @[User::tableName] + ";"

Also set the property EvaluateAsExpression to True

Remove any Parameter...

What were you thinking of using SSIS for?

You could also take a look at the table ExecutionLogStorage in the ReportServer database

This holds a log of reports run along with criteria