Viewing 15 posts - 5,476 through 5,490 (of 59,068 total)
I don't know of any EDI spec that doesn't use an"*" as a delimiter but people are known to make up stuff as they go along and so understood on...
March 15, 2021 at 12:06 am
The linked article states that "If a date is neither a holiday, nor a weekend day, it is a workday." But that's not true. Businesses may be shut because...
March 14, 2021 at 10:32 pm
Thanks for the feedack, Jeffrey...
I totally agree that trying to fully parse EDI files in SQL Server is a bit crazy and even I probably wouldn't go there, especially since...
March 14, 2021 at 7:29 pm
I have to agree with Jeffrey Williams here. The files are EDI files and the "*"s are actually delimiters. If you use positional notation instead of the element ordinal after...
March 14, 2021 at 4:22 pm
Hi Many thanks both for your help on this!
For some reason, I get the message Invalid object name 'dbo.DelimitedSplit8k'. Could I need an update for this?
See my post right...
March 14, 2021 at 1:36 am
Oooooo... now that's interesting... I did a quote of an existing post at 1:58PM and the SPAM deletion that had to have occurred AFTER that is marked as having occurred...
March 13, 2021 at 10:58 pm
The above lookups are in the 1st record in file using criteria above. I need some help ...
THanks.
What's stopping you from reading the first two rows using...
March 13, 2021 at 10:53 pm
Your database is not normalised.
The standard way to store this is to have two tables instead of your #u table
It's a work table, Jonathan.
March 13, 2021 at 10:37 pm
Heh... my observation has been that a lot of people think they need to scale out but, in truth, it's because of bad database design, improper use of ORMs, and...
March 13, 2021 at 10:35 pm
Ok... if we're going to go "there", then why doesn't the front-end where the "pull-down" lives do this and occasionally upload from the Fruit table to keep it in synch? ...
March 13, 2021 at 10:27 pm
CryptoLocker ransomware or similar malware is distributed through spam email campaign. Scammers or attackers send spam emails in your mail box which contain messages along with malicious attachments or...
March 13, 2021 at 6:58 pm
Ah... sorry... you can read the article about how the DelimitedSplit8K function works at the following article...
... and a serious performance enhancement to the code by Eirikur Eiriksson in...
March 13, 2021 at 5:38 pm
It would be a lot easier to do using STRING_AGG() in SQL Server 2017 and up but, since this is a 2014 thread, we'll have to do it the old...
March 13, 2021 at 5:33 pm
BULK INSERT #CUSTOMER FROM 'E:\Loyalty_DWND\A22679.csv' WITH ( FIRSTROW=2, --DATAFILETYPE = 'char', FIELDTERMINATOR =',', ROWTERMINATOR = '0x0a', -- CODEPAGE = '65001', TABLOCK, FIELDQUOTE='"', FORMAT='CSV'
)
That would do the trick in 2017...
March 13, 2021 at 3:59 pm
The above lookups are in the 1st record in file using criteria above. I need some help ...
THanks.
What's stopping you from reading the first two rows using Bulk Insert...
March 13, 2021 at 2:46 am
Viewing 15 posts - 5,476 through 5,490 (of 59,068 total)