Processing a resultset to look up foriegn keys (and poulate a new table!)
- by Gilly
Hi, I've been handed a dataset that has some fairly basic table structures with no keys at all. eg
{myRubishTable} - Area(varchar),AuthorityName(varchar),StartYear(varchar),StartMonth(varcha),EndYear(varchar),EndMonth(varchar),Amount(Money)
there are other tables that use the Area and AuthorityName columns as well as a general use of Month and…