Not that it makes too much difference, but what is the input format? Is it a single delimited string, or a recordset?

So this should be fine? select a.*, b.full_name from alt_id_view a left outer join all_clients_view b on a.people_id = b.people_id It's only bringing in the matched so it could...

Hello, I am trying to see all records, even those which do not have a match on table b. I tried full outer join but the results were the...

It just depends on the nature of the table.. if I can avoid deleting data I prefer to do it another way, whether that is checking if the table...

• This reply was modified 6 years, 8 months ago by Phil Parkin. Reason: Improve English

There is no guarantee that CHECKSUM_AGG() will return a unique value for every different recordset, so 'fixing' the proc is not really an option unless you are prepared to use...

...

Right now, my priority is to wait a few more days for the water to warm up. Predicting some time to relax and pull in some crappies. And maybe...

Could be the 'new' cardinality estimator (introduced in 2014). Lots of links all over, but you could start with this.

Please describe the problems you believe TRUNCATE introduces which...

I think this is right ...

As you have defined the datatype of the input parameter to be date, the error you see happens before the proc executes. You need to...

I understand your requirement, but unless you post the SQL you have tried, it's difficult to help you any further.

As far as I know, you have to delete and recreate precedence constraints. It's a pain, I agree.

Regarding your second post, is that a question?

Wouldn't this be unethical?

Do a left join from a table, or virtual, dynamic table, which contains all of the years you wish to display.

Hello Phil Thanks for your answers. - We have 50 tables that could be refreshed. Depending of the day, we receive data for a specific destination table. So column...

I agree that this is a horrid idea.

It is, however, pretty easy to solve. Put a Script task before each dataflow and add a wait there, possibly something like this...