Weighted random selections in SQL Server

There are no built-in functions for selecting weighted averages in SQL Server. Fortunately it's a simple task to do so oneself.

Read the complete 1755 bytes...

Digg it | Kick it | Dzone it | Reddit


Automatically mapping datatable to objects

I often need to transfer data from my business layer to my presentation layers in a strongly typed way. In this example I'll use the following very struct and corresponding DataTable to represent the data I need to transfer:

Read the complete 3308 bytes...

Digg it | Kick it | Dzone it | Reddit