Generating Dummy Data

A quick and easy way to generate test data for load testing.

The Lonely and Neglected Cartesian Product (Cross Join)

Rounding

I'm trying to ROUND to 2 Decimal Places. The query is below. The Value Column is a MONEY DataType!When I execute the query below, it doesn't ROUND to 2 Decimal Places. THe result is the same, it has 4 digits after the decimal!Is there a trick to this?SELECT AccountID, ROUND(SUM(CASE WHEN Value < 0 THEN […]

SqlAgentMail does not work with win2003 server

 We just upgraded our database (sql 2000 sp3) to a new machine running windows 2003 server os.We are also running ms-exchange 2003 passive on this node for our cluster.SqlMail works but SqlAgentMail does not. This is because SqlMail can use the newest version of mapi32.dll and SqlAgentMail uses Mapi0 which is not supported on win […]