In refrence to CLR, using stream classes:

If you are streaming a file rather than from memory, the complier will make you flag the assembly as External Access (or unsafe), since...

CTE are nice, haven't used as much as I like to, but nevertheless they bring a nice feature forward to 2005. Just found a good article on CTE's and recursive...

It was actually for a paramter in a previous project where I was getting a list of custid's comma dilimited. When I attempted to write in Tsql I had to...

I look at XML as the bridge between data and presentation layer, with a simple tweak of some xml files that define my presentation and a data structure I get...

A real quick and easy way to make a split funciton, that returns records as a table.

Imagine writing that in TSQL???