I don't think you can because the hash is created internally based on a structure in the optimizer, not the T-SQL text, that would also have to be recreated....

For 10,000 rows, it could well be faster (and simpler to code and maintain) for you to do a full truncate/reload every time.

Unless you have a reason not to?

Which hash are you referring to?

Which tool are you wanting to calculate the hash with?

Which engine are you referring to? The Mazda I have at the moment is pretty fast,...

I don't think you are missing anything simple.

Are you able to revisit the 'data must be live' requirement? If it transpires that a 10-minute latency period is acceptable, it potentially...

Going back to the script task, you do not need to know variable names in order to iterate round the variables collection. Here's a chunk of code I copied from...

• This reply was modified 7 years, 4 months ago by Phil Parkin.
• This reply was modified 7 years, 4 months ago by Phil Parkin. Reason: Improve C# snippet

As you are using an expression to define the Execute Process command, I would suggest that you put a debug breakpoint on the EP task and then check the run-time...

OK, is part...

How did the data previously get from the remote databases into your locally hosted 'existing' table?

Have you tried setting a breakpoint and then inspecting the contents of the various variables? Might provide some useful insight.

Also, if you are looping round resp.ResponseData, what is the point...

What is the exact text of the error message?

Is this something which used to work and has suddenly stopped, or has it never worked?

This post may be of interest.

I'll reproduce the code here:

DECLARE @s VARCHAR(25),
@Iteration INT;

SET @s = 'ABCDEF';

SET @Iteration = LEN(@s);

WITH E1 (N)
AS (SELECT 1
UNION ALL
SELECT 1
UNION ALL
SELECT...

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 7 years, 4 months ago by Phil Parkin. Reason: Improve English