Viewing 15 posts - 196 through 210 (of 607 total)
Add a formula in C2, =IF(A2="",A2,A1), copy down the whole list, then import using that new column as your user.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 5, 2019 at 6:29 pm
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.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 25, 2019 at 3:10 pm
I'm assuming you haven't tried any of the above. Only one additional suggestion:
http://lmgtfy.com/?q=sql+server+training
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 23, 2019 at 8:35 pm
I just execute all the plans and let SQL sort it out
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 17, 2019 at 3:33 pm
Pragmatic Works is great too
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 16, 2019 at 2:32 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 12, 2019 at 9:16 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 12, 2019 at 7:20 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 12, 2019 at 6:56 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 10, 2019 at 6:41 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 10, 2019 at 6:28 pm
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
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 10, 2019 at 3:17 pm
something like this? https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/group-object?view=powershell-6
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 8, 2019 at 3:13 pm
Sergiy, please. Mobile version "above the fold"? From deep within a topic in a forum? That's cherry-picking.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 2, 2019 at 11:34 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
July 2, 2019 at 11:33 am
Also, not being a punk and reviewing the code for whether it works correctly, instead of just looking for "what changed"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 27, 2019 at 3:54 pm
Viewing 15 posts - 196 through 210 (of 607 total)