Standard Numeric Format Strings for SQL Reporting Services

Here are the Standard Numeric Format Strings for using in MS SQL Reporting Services.

MS failed to include these with their documentation with the product.

Entering Large Time Values in Excel

Entering Large Time Values: "[h]:mm:ss"

How to Close All Files Opened by Network Clients from the Command Line

How to Close All Files Opened by Network Clients from the Command Line




Command to Close All Open Files
for /f "skip=4 tokens=1" %a in ('net files') do net files %a /close

The command works by passing the file ID elements from the list produced by the net files command to the action argument of the for command, net files file ID /close. When you use the iterative substitution (%a in this case) as part of a batch file, the substitution needs to be %%a. For the batch file version of the command, use the following syntax:

for /f "skip=4 tokens=1" %%a in ('net files') do net files %%a /close

In both cases, this command will appear to return an error because the last line of output from net files is "The Command Completed Successfully" and there is no file ID denoted as "The".

Note: The Server Service must be running in order for this command to work.