Viewing 15 posts - 2,401 through 2,415 (of 2,663 total)
Good to know it was my expected "error".
It is a pain for those that don't know better - but in terms of security this is how it should...
May 25, 2018 at 11:40 am
May 25, 2018 at 3:43 am
May 25, 2018 at 3:37 am
you need to change your code to send a string, not a list
something like (untested and not necessarily correct from a syntax point of view)
Cmd.CommandText = "SP_Insert_WC000311A_PremFormData"
May 22, 2018 at 9:52 pm
can she really not do it or does she just get a warning stating she may not be able to do it? similar to https://sqlstudies.com/2014/07/10/db_ddladmin-and-the-ssms-table-designer/
or does she get a...
May 22, 2018 at 9:16 pm
always output and visually compare on hex on these cases where it looks the same
(change 500 below as required to hold the content of the fields)
SELECT EmplID
May 22, 2018 at 11:52 am
May 21, 2018 at 7:32 am
Steve,
As far as I can see its not Luhn 10 checksum but rather processing the numbers at the bottom of a printed cheque/check - https://en.wikipedia.org/wiki/Magnetic_ink_character_recognition
the regex...
May 21, 2018 at 1:21 am
I would say your only option is to use a CLR to do it.
https://www.google.ie/search?q=clr+regex+c%23&oq=regex+clr&aqs=chrome.2.69i57j0l5.5556j0j7&sourceid=chrome&ie=UTF-8 will give you some examples
or eventually R https://www.mssqltips.com/sqlservertip/4748/sql-server-2016-regular-expressions-with-the-r-language/
May 20, 2018 at 5:05 pm
That is not a local drive then - it is a cluster resource which is not what this thread is all about
May 20, 2018 at 8:36 am
Being on the NAS may be the problem - drive should be local, not networked.
This probably should be added as a disk through VM for it to work outside...
May 19, 2018 at 7:21 pm
Tom what is the SQL version you are using?
May 19, 2018 at 6:18 pm
I am sorry but not much you can do without them fixing the extraction of the data.
Lets analyze the sample you gave us - which I trully...
May 19, 2018 at 1:40 am
Is that really the content of the file? if so it is a piece of crap data really.
ADV ,A_DAT ,A_TIM ,P_tit ,S_Tit
"SOCLEAN INC","5/16/2018","14:39:44",""Z-QUNICY,"DR K 60...
May 18, 2018 at 1:34 pm
Take in consideration what Steve and Sue said and look at better/correct ways of doing your process.
However just as a possible rewrite of what you have you can...
May 15, 2018 at 1:44 am
Viewing 15 posts - 2,401 through 2,415 (of 2,663 total)