Viewing 15 posts - 4,396 through 4,410 (of 13,876 total)
Not exactly considered best practice, but if you don't care which dupe gets dumped, you could consider setting IGNORE_DUP_KEY = ON on your PK to ignore dupes silently (
June 4, 2018 at 9:06 am
Does anyone know or suggest a way to extract column information from the Json...
June 1, 2018 at 12:55 pm
June 1, 2018 at 12:38 pm
June 1, 2018 at 11:28 am
Ryan007 - Friday, June 1, 2018 7:36 AMThis will act as test environment not only for developing software.
OK, so what else will...
June 1, 2018 at 7:41 am
May 31, 2018 at 1:23 pm
May 31, 2018 at 11:25 am
IF OBJECT_ID('tempdb..#RX') IS NOT NULL
...
May 30, 2018 at 1:43 pm
May 30, 2018 at 1:00 pm
These features...
May 30, 2018 at 7:00 am
We are planning to create a dedicated server for SSIS. SQL 2016 will be...
May 30, 2018 at 6:44 am
You could also add the decoded monthname to the CROSS JOIN:
CROSS JOIN
(
SELECT m = 1,
mth = 'January'
...
May 30, 2018 at 5:21 am
May 29, 2018 at 11:40 am
It's not that difficult, but there are some tricks required.
1) Define the flat file source rows as single columns
-- So every source file row is (initially) treated...
May 29, 2018 at 7:46 am
May 29, 2018 at 6:18 am
Viewing 15 posts - 4,396 through 4,410 (of 13,876 total)