Viewing 15 posts - 2,386 through 2,400 (of 2,646 total)
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
on the counts replace the "else 0" with "else null"
e.g change
COUNT(distinct (CASE WHEN obranome LIKE 'C%' AND etotaldeb <> 0 THEN obrano ELSE 0 END)
to
COUNT(distinct (CASE...
May 12, 2018 at 5:53 am
If referring to PowerBI Report Server then any will do - but be careful with licensing - either you have a Enterprise edition with SA (and you can then install...
May 8, 2018 at 11:25 am
Viewing 15 posts - 2,386 through 2,400 (of 2,646 total)