Search results 134

Sorted from new to old.

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Feb8

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

2023Nov12

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

1 2 ...8 9