Viewing 15 posts - 4,516 through 4,530 (of 13,871 total)
Apologies, I've been away from work and not had chance to work on your...
April 17, 2018 at 8:58 am
April 17, 2018 at 8:38 am
April 17, 2018 at 6:53 am
SELECT *
--SET B.Archive = 'Y'
FROM (
SELECT *,
...
April 16, 2018 at 11:25 am
I need a help from you. Could you please confirm is it possible to parse...
April 16, 2018 at 10:35 am
Thank you very much.
I guess I found a cool solution that I would like to post...
April 16, 2018 at 9:37 am
Hello,
Thank you for your reply. Not sure I undertood your answer.
Maybe what I will do...
April 16, 2018 at 7:47 am
Hello,
Because this file is generated by a provider that is sending this infromation for free....
April 16, 2018 at 7:33 am
Can I ask why you are doing this rather than loading directly from the file to a table?
April 16, 2018 at 7:12 am
April 16, 2018 at 6:49 am
April 13, 2018 at 11:44 am
The exclamation mark and tilde are easy enough, but those square brackets are a challenge. I cheated by doing this:WHERE REPLACE(REPLACE(w.SomeText, '[', ''), ']', '') LIKE...
April 13, 2018 at 11:26 am
Try changing your search string to this'%[^-a-zA-Z0-9.&_#$\\() ]%'
I believe that the hyphen was causing you problems, because it is interpreted as a range separator, unless it occurs...
April 13, 2018 at 10:51 am
Please provide sample DDL and INSERTs for your data. I think you may need to expand on the summing logic you require too, as I do not understand it as...
April 12, 2018 at 1:43 pm
Viewing 15 posts - 4,516 through 4,530 (of 13,871 total)