Recent content by ScotWilder

:D Absolutely perfect, many thanks!! All I did in addition was added the 'donecount' to the front of the statement so it read as '14 = 10% of 146' (example)

Hi folks, Having a major head scratch moment with percentages in t-sql output, I need the end result of a count 1/count 2 output to be a percentage value of 00.00% (e.g. two decimal places. The result of this example should be count 1 (14) / count 2 (146) = 9.59% I've seen a separate thread...

Hi folks, I have a requirement to automatically populate a table based on the contents of a specified folder. The file-names follow a protocol of the below - 180936-556849.doc The extension can be different, e.g. docx or pdf, so the action would be to 1 - Find the directory 2 - Clear the...