Jeff, I think your bracket should be after 'AND', not before it.

--OK, let me have another attempt at this post!

Your logic seems solid.

I think you need to compare the two sets of results, identify the differences and see whether you can...

• This reply was modified 5 years, 10 months ago by Phil Parkin.
• This reply was modified 5 years, 10 months ago by Phil Parkin.

OK, it's not very elegant, but using this

SELECT RightNow = convert(VARCHAR(30),GETDATE(),21)

and saving to a string worked for me.

Try using DT_DBTIMESTAMP as your SSIS datatype.

Yes you are right and I thought you should be this totally works but mint does not.

And I agree totlay this should work,  looks like what I am doing...

as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same...

This varies from one organisation to the next. I've seen all combinations.

Having said that, you can usually apportion all of the "why is it so slow?" blame solely to DBAs,...

Building the update query using dynamic SQL is one way. Alternatively, something like this should work:

UPDATE t
SET FirstName = IsNull(@first_name, FirstName), 
    LastName =...

To what? Certainly not this post.

If you are not prepared to answer any of the questions which people are directing at you, don't be surprised at the...

I have an alternative approach for you to consider. It relies on the following assumptions:

1. All of your databases are scripted and in source control
2. Cross-database references use three-part names...

Did 'he' say whether this is a one-off requirement, or something which will need to run periodically?

Thank you, Frederico. I'm at work again. Without local admin access, it seems I cannot adjust perms for those folders.

(I had already run the sp_MSset_oledb_prop commands though.)

Regarding the bug ... is that the one where you hit 'Edit Script' only to find that you are presented with a blank script? I've seen that in 2017 too...

There are faster/better ways of obtaining total row counts. Here's one:

SELECT TotRows = SUM(row_count)
FROM sys.dm_db_partition_stats
WHERE object_id = OBJECT_ID('schemaname.tablename')
      AND index_id < 2
GROUP...

Hi all, I've (finally!) tried to get this working again, this time from my office PC. Unfortunately, with exactly the same outcome.

The SQL Server service is running under the NT...