I've heard of modelling tools, but then I've heard of unicorns and phoenixes as well

To me Key = Index.

AK1 needs to be a unique key if you are going to do this, otherwise you will take an AK47 to your data integrity.

As...

Note POWER will give an arithmetic error if you exceed 31 issues because POWER can only return a 32 bit integer.

DECLARE @tbl TABLE(Id Int , Issue CHAR(8))

DECLARE @byLoop TinyInt

SET @byLoop=1

WHILE @byLoop<32

 BEGIN

  INSERT @tbl(Id , Issue)

  SELECT POWER(2,@byLoop-1),'Issue ' + CAST(@byLoop AS VARCHAR(2))

  SET @byLoop=@byLoop+1

 END

SELECT * from @tbl

This design limits the number of possible values to:

• 31 if the Int field is used.
• 63 if the BigInt field is used.

If you are happy with that then why not prepopulate...

Personally I would have three tables.

• Customers
• Models
• CustomersToModels

If you haven't already done so I would create an integer field to act as the primary key for the Customers and Models table.

On the...

I am assuming here that you have performed some form of large delete operation and want to shrink your database file?

Firstly, do a DBCC DBREINDEX on that tables from which...

In what way Jamie, what were you looking for?

Been there, done that.

In any organisation, be it social, business or what ever there seems to be four types of people.

1. Inspirational and dynamic.
2. The willing workers.
3. People along for the ride.

An organisation...

I agree that keeping documentation up-to-date is an absolute pain in the arse but when you need it and it isn't there you are in trouble.

I work for a company...

SELECT TOP 1000 WITH TIES DT.telephoneid , DT.Requests

FROM (

SELECT telephoneid,count(*) AS Requests

FROM tbl

GROUP BY telephoneid

) AS DT.

ORDER BY DT.Requests DESC

This will return the TOP 1000 but also take into account...

I am very much of the opinion that it is small inch pebble steps that change the world rather than the big bang approach.

If you take a step out of...

I would plan to convert the queries over time because Access can cause huge locking problems.

Someone on this site recommended using pass thru queries but that means converting your queries...

Actually, 15 miles probably isn't enough!

On March 29th 2004 in Manchester UK an underground fire in a tunnel containing telecommunication wires took out an area that certainly extends to where...

This confirms what is written in BOL i.e. each table can only appear once in a cascade relationship and you can't have circular references.

Basically, you have to design your database...