"Since the SP RunMe only adds one row each time it is run there will not be more than one row in the inserted table. When you execute the second...

I think some people have got a wrong idea of a lookup table. It is not an entity per se. It holds discrete values and their meanings that are...

Robert,

If you venture into UK and Australia, note the differences in Postcodes.

In the UK, the full postcode, if I am not mistaken, indicates the "block" as you say it...

Just add a column-header to the count, as in:

SELECT tbParents.*, Sitters=count(tbPcodes.pcMyZips) FROM tbParents, tbPcodes

WHERE tbParents.pZipCode = tbPcodes.pcMyZips AND tbPcodes.bsID > MMColParam AND tbPcodes.bsID < MMColParam2

group by tbParents.*

ORDER BY...

I've seen many a commercial product that has been implemented without PKs and RI (presumably to keep their product a trade secret!). The poor DBA then gets the blame...

I have a lot of respect for Joe Celko. However, I bend the rules sometimes. And look-up tables are precisely where I bend the rules, and the resulting...

Not if the values are few discrete values, such as state, which can be defined into the table definitions as a CHECK constraint. The CODE_TYPES and CODES tables I...

I have been using a similar concept (since the days of COBOL 🙂 i.e. 1982 ), having a table ot CODE_TYPES and another one of CODES. I don't...

Hi Michelle,

All tables that I design have the following columns:

DateCreated

UserCreated

DateModified

UserModified.

where the first two are not null and last two can have nulls.

The software I develop updates these columns...

1. Create a table, say Months (MonthNo varchar(2)); populate this table with numbers 1 to 12, representing the months

2. Query now becomes:

SELECT M.MonthNo AS [Month], Count(P.DatePkgSent) AS AmountSent

FROM PotentialClients...