Viewing 15 posts - 31 through 45 (of 597 total)
And now, how to put the brakes on a migration project...
Break your wrist on a bicycle ride so you only have one hand to type with and no immediate...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 15, 2020 at 12:46 pm
Agreed with both of the above, everyone creates their own gates because it helps their sanity. Being able to work with people means controlling the chaos from both sides and...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 12, 2020 at 2:35 pm
So, you want to split the values in the first table, and return results WHERE Country NOT LIKE('%'+split.Value+'%') , right?
Edit: I would say, first suggestion is to normalize the data...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 11, 2020 at 6:48 pm
David.Poole wrote:Still wearing SQLBits clothes from 2014!
That's a really long time, David. You should at least change your underwear every one or two weeks. 😀
I think that's probably enough...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 11, 2020 at 6:42 pm
I've been working from home for four years now, and I think it's more about your management comfort level and the specific people involved that drive this decision. My manager...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 11, 2020 at 6:35 pm
So much for my dreams of the epic saga of the SELECT as told by the heroic defender of the faith....
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 10, 2020 at 6:53 pm
Honestly, a little excited to go vote for "this page is full of hooie"...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 10, 2020 at 4:56 pm
#2. because it's probably just something the authors at Microsoft didn't put in as usual terminology (low value change, may not have been a concept they even considered). You could...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 10, 2020 at 3:18 pm
https://www.sqlshack.com/importexport-json-data-using-sql-server-2016/
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 10, 2020 at 1:29 am
Check out https://qa.sqlservercentral.com/stairways/stairway-to-xml, that should get you started.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 9, 2020 at 11:47 pm
You're going to have to find the data. If you're running this on a regular basis to move stuff in, check this out:
uses Try/Catch blocks, you can attempt everything...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2020 at 7:14 pm
Add in WHERE tp.Field1 LIKE '%.%' and you won't have any errors. Won't parse anything either, but that wouldn't happen anyway.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2020 at 6:53 pm
You know what, is there a timestamp on when the process ran on that table? createdate or something? you could just set up the notification email to run on a...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2020 at 3:41 pm
might seem like overkill for the question you posed, but trust me, you'll use it many times, it's worth borrowing from Jeff et al.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2020 at 1:54 pm
If you have ErrorCreated, then you have to store what the message is separately. If you use the presence or absence of a message in ErrorMessage, then you know what...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 4, 2020 at 1:50 pm
Viewing 15 posts - 31 through 45 (of 597 total)