I took Shaun's recommendation and found a good article here: http://www.sqlservercentral.com/articles/TSQL/62867/.

I never heard of a Tally table before. This is good stuff. I already know places where I...

I'm having trouble understanding Step 4. Where do tables 'TAB' and 'Tally' come from?

Thanks,

Tim

Insert into SOURCE(Name, Age, Sex)

Select Name

, Age

, CHAR(ASCII(Sex) & 1) --extract and preserve the [Sex] field

From...