Archive for May, 2011
Coalesce Function
The COALESCE function in SQL returns the first non-NULL expression among its arguments. It is the same as the following CASE statement: SELECT CASE (“column_name”) WHEN “expression 1 is not NULL” THEN “expression 1” WHEN “expression 2 is not NULL” THEN “expression 2” … [ELSE “NULL”] END FROM “table_name” For examples, say we have the […]
Read moreSQL Math Functions
he following is a reference to the main math functions in SQL: ABS(X) Absolute value-converts negative numbers to positive, or leaves positive numbers alone CEIL(X) X is a decimal value that will be rounded up. FLOOR(X) X is a decimal value that will be rounded down. GREATEST(X,Y) Returns the largest of the two values. LEAST(X,Y) […]
Read moreESET Remote Administrator
Deze tool biedt effectief en centraal op afstand beheer aan voor ESET NOD32 Antivirus en ESET Smart Security in zowel LAN als WAN netwerken. ESET Remote Administrator wordt meegeleverd met alle Business Edition producten. De nieuwe versie van ESET Remote Administrator biedt een breed scala aan nieuwe functionaliteiten en verbeteringen ten behoeve van het gebruikersgemak […]
Read moreLansweeper: hardware, network and software inventory for windows networks
Lansweeper is an automated network discovery and asset management tool which scans all your computers and devices and displays them in an easy accessible web interface. There is no need to install any agents on the computers, all scanning is done by standard build-in functionality.
Read moreCCleaner Network Edition
Introducing a new efficient way to use CCleaner in the business and enterprise world. CCleaner Network Edition, is a scalable network version of CCleaner that allows remote deployment and management. Use the awesome system optimization power of CCleaner, across your entire network with only a few clicks.
Read moreSummarizing by month and year with datepart
There are many ways of searching and doing date calculations. SELECT DATEPART(yyyy,sales_date) AS ‘Year’, MAX(DATENAME(m,sales_date)) AS ‘Month’, COUNT(sales_date) AS ‘Units per Month’ FROM sales GROUP BY DATEPART(yyyy,sales_date), DATEPART(mm,sales_date) ORDER BY DATEPART(yyyy,sales_date), DATEPART(mm,sales_date);
Read more