Viewing 15 posts - 10,231 through 10,245 (of 59,065 total)
December 21, 2018 at 2:06 pm
edwardwill - Friday, December 21, 2018 3:28 AMCould you provide a link to an authoritative resource, please?
This is one of those "If...
December 21, 2018 at 9:22 am
I do use the error sequestration functionality of BULK INSERT but I hate the cryptic messages it stores. I've never understood why the messages can't be more like the ones...
December 21, 2018 at 9:19 am
December 21, 2018 at 8:43 am
December 21, 2018 at 7:53 am
December 20, 2018 at 10:49 pm
pietlinden - Thursday, December 20, 2018 8:33 PMThis might be a helpful read:
https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Lordy, don't use REORGANIZE. It'll take longer, beat the...
December 20, 2018 at 10:46 pm
Since you're using SQL Server 2012, DATEFROMPARTS with substrings to isolate the parts might be the fastest.
Of course my initial thought is to ask that they send...
December 20, 2018 at 10:36 pm
Welcome. I suggest that you first download a free copy of SQL Server 2016 or 2017 Developers Edition, install it on your computer, buy a book on the subject and...
December 20, 2018 at 10:30 pm
I am trying to get distinct values from multiple filed on multiple lines per "client"
example
Client ...
December 20, 2018 at 10:24 pm
December 20, 2018 at 1:32 pm
December 20, 2018 at 1:06 pm
Heh... hold the phone.... If you have a user ID (and assuming that it's unique), why do you need another surrogate key to begin with??? :blink:
December 20, 2018 at 8:59 am
I have to agree with Eirikur... Keep It Super Simple. If you must use SSIS for this, have it call a stored procedure that does what he said.
December 20, 2018 at 8:56 am
Viewing 15 posts - 10,231 through 10,245 (of 59,065 total)