Search results for query: *

using MD5 will give you less chance of a collision (or, any of MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512 ) the hashbytes function takes an algorithm, and a single variable. e.g. select hashbytes('MD5','madonnac') : 0xD7CA39B7F7F21CB229DC3DA72E17C064 select hashbytes('MD5','COOK...

slice the string up. Case will recognize date format #107 (mmm dd, yyyy), which is only slightly different to your format declare @d varchar(40) set @d = 'Mar-01-2016' select cast(left(@d,3)+' '+substring(@d,5,2)+', '+substring(@d,8,4) as datetime2) You should be able to use things like...

Chris, Add a /D to that, and it will also handle directories: ATTRIB -R *.* /S /D

VLOOKUP will also work for this =A1 & " " & IFERROR(VLOOKUP(A1,Sheet1!$A$1:$C$55,3,False),"is NOT on the Table")

Unfortunately, I only have 2010 and 2013 to check this, but there should be a proofing option, where you have an Autocorrect section. This should allow you to disable the autoformat of name and email address. As to the name/email fixing, this horrible looking formula will try to fix the data...

ISERROR is an optimized version of IF(ISERROR( Cell(2) Cell J49 =K49/I49 would become Cell(2) Cell J49 =IFERROR(K49/I49,"") Note that this will trap all errors, so things like #VALUE! , #NA! and #ERR! will also be caught

I am running CMS Supervisor V 16.2.KC.12 If I select manual login, I can log into the servers with no issue. If I uncheck that box, it just sits at "Initializing, and does not get any further. One server is R16.2, the other is R14. Both show the default terminal as cvsup on the manual login...

With this code to run a stored procedure: Set cmdl = New ADODB.Command With cmdl .ActiveConnection = StrCon ' Connection to the Database 'set COMMAND timeout property - query can time out on either the connection OR the command .CommandTimeout = 0 .CommandText = "spCrossTabRun"...

Try connecting to \\OtherCompterName\c$ - the c$ is an admin share, which will require the Admin user/pass for that computer. Note that the admin password has to exist - a blank password will refuse connections from other computers using that name e.g. UN:AdminBlank, Password:<none> -...

Index: use of the 0: If you set row_num or column_num to 0 (zero), INDEX returns the array of values for the entire column or row, respectively. or If you set row_num or column_num to 0 (zero), INDEX returns the reference for the entire column or row, respectively There is nothing wrong with...

To sum a 3-D array, we need to use an array formula First, the easy part - The Section: (A2:A4="A") This will give us true or false for each row. Then we work down the rows, and see if the date is correct: IF(B1:D1<TODAY(),B2:D4) We multiply each row by the true/false from the section, which...

The easiest way is with an IFBLANK test. =IF(ISBLANK(YourCellFormula),"",YourCellFormula)

you may need to adjust the vbLf constant, depending on the values that force the new line vbLf is the LineFeed character, chr(10) vbCR is the Carrage Return character, chr(13) vbCrLf is both combined into one These selections cover 95% of the cases. Create a UDF function: Function...

yes, and I can edit both reports to show the other calculation, which shows the discrepancies.

I have 2 reports (designed by different people) that use 2 separate calculations to work out total call time (without ACW) One uses ACDTIME + HOLDTIME The other uses i_acdtime + i_acdothertime + i_acdaux_outtime Looking at the definitions in the Avaya help file, they would seem to be...

Hi Whitemtntn It seems you've posted the same question at microsoft technet forum Please see: http://www.excelguru.ca/node/7

Unfortunately, there's no ODBC driver for a paper table. It needs to be entered into the computer... Are they expecting you to set up a webcam so you can take a picture of who is operating the machine? Perhaps OCR scanning so you can read the paper they log the user on? With the information...

As I assume you're trying not to overload a circuit, we will have to restart the numbering when the next value would overload the previous branch. This requires a helper column. Unit HP VFD Brake FLA Branch load Branch # 4104 5 No Yes 7.6 7.6 1 4106 2 No No 3.4 11 1 4108 2 No No 3.4 14.4 1...

Copy the access database to another location - this may be automated/run on a regular basis Use that database as a backend to your database. That way, you are linking to a snapshot of the database, and not connecting to the original in any way, so if someone does affect the data, you can simply...

Windows Solitaire was designed to introduce people to the mouse - you can drag & drop cards on the layout - you can double click them to put them up onto the target piles (Ace, 2, 3, ... ,K) - You can click on Menus to start new games, etc - you can use shortcut keys (F2, F3, etc) to...