You won't be able to use Windows Authentication to connect to a SQL Server INStance on a different host unless you in a domain; like you said Windows Home Edition...

Have you had a look at ROW_NUMBER? Specifically, you need to make sure you at your PARTITION and ORDER BY expressions. I suggest having a look at the...

The post you...

Are you not looking for CONTAINS (Transact-SQL)? Even so, if your LIKE isn't returning a result, that means that no rows contain the string "mypartialstring".

I recommend against Overwrite Datasources and Datasets being set to True; especially if you're working with Dev and UAT environments.

If a folder doesn't exist on your server when...

I think the thing that I really care about when i hear a company I use, or I'm looking to, has a data breach is how much that put into...

Otherwise, RedGate offer a tool called Data Masker.

If the columns all have the same name, and definition, why not just use some dynamic SQL?

Give this one a go:

Why not:
[Code]
SELECT TOP 1 WITH TIES
       ID, MY_STATE, EVENT_TS
FROM #TAB1
ORDER BY ROW_NUMBER() OVER (PARTITION BY ID ORDER BY EVENT_TS DESC);[/code]

When posting, you should really show your attempts too; it really helps us understand how far you've got and may mean that we don't have to do all the work...