Add a formula in C2, =IF(A2="",A2,A1), copy down the whole list, then import using that new column as your user.

Can I query a different database and join multiple tables together in one query, combining with data in the source database? That seems rather straight-forward, but maybe not.

I'm assuming you haven't tried any of the above. Only one additional suggestion:

http://lmgtfy.com/?q=sql+server+training

I just execute all the plans and let SQL sort it out

Pragmatic Works is great too

So today got awesome. Just minding my business, had a request in to start a Git repository for my team to finally get us into source control and out of...

Not suggesting Des is wrong, but something to take into consideration:

To use TABLESAMPLE, this clause is put after the FROM clause as follows:

...FROM tableName TABLESAMPLE (10 PERCENT)

...FROM tableName TABLESAMPLE (1000...

SELECT TOP is not ordered, it's just limiting the number of results. If you have an ORDER BY clause, that's ordering. What are you trying to accomplish, that you don't...

right, but the "stockCode IN (...list...)" part has to be matched by finding codes that actually exist. You don't have stockCode [4 2015] in your data, and you really wanted...

Your stock code is not [4 2015], that's the month and year. it's working, it's just that you aren't asking for what you want.

select * from
(SELECT mon...

duplicate post of https://www.sqlservercentral.com/forums/topic/in-below-script-in-place-of-it-is-displaying-how-to-avoid-amp, see answer there

something like this? https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/group-object?view=powershell-6

Sergiy, please. Mobile version "above the fold"? From deep within a topic in a forum? That's cherry-picking.

Can we complain about some user questions or something? I think we've established that some folks don't like the new site layout, but that Steve has listened and done what...

Also, not being a punk and reviewing the code for whether it works correctly, instead of just looking for "what changed"