Happy Christmas Joe 😛

Which reminds me.

Q) Why do Assembly programmers get Xmas and Halloween confused

A) Because OCT31 = DEC25

Anyway, JC wouldn't touch Progress with a barge...

Front end developers love EAV tables because they can quickly built an interface that allows users to configure the properties of an entity (think a website that sells books and...

Thats not a circular reference.

tblGroupUser is a cross-ref or bridge table to normalise the Many:Many relationship betwen users and groups. It allows one user to belong to many groups...

Are you talking about application performance or reporting performance.

If it is reporting, then I woudl be tempted to replicate the database and create reporting indexes. In a large system...

Create table Universe

(

SpaceTime VeryVeryVeryVeryVeryBigInt not null

)

It will do. A blank column inicates an unknown value - the equivalent of NULL. One of the problems when dealing with Excel is that the cell value...

Oops!

I should know better than to make throwaway statements like that when Jeff or Gill are lurking 😀

I will have to find some time to set it up on my...

I'm With Sean!

To get the table into a managable state, copy the records you want to keep then truncate the real table and then either drop it and rename the...

Or synonyms if you might need to switch schemas between development and production, or for different clients (e.g. data segregation is done by schema rather than by database - I've...

That, my friend, would be a whole different thread 😀

My data sources are spread across a number of different technologies (SQL2000, 2005,2008, Oracle 11i, 12, Progress 9, 10, as well...

or can you set it up as a passthru query and let the source server develop an execution plan

Drat! 🙂

I suspected that was the case. Looks like I'll be building it myself then.

Yup, Its a standard LEFT JOIN problem.

give me all the records in the starting table (list of email addresses supplied) and the matching record in the right hand table (stored...

The short answer is that you should re think your database.

From the question it is clear that the field is storing at least three separate entities:

Sector (3-13) - varchar

PropertyID (414)...

Thanks guys,

The Entity.NaturalKey will definately be indexed in some form as it will be displayed on most granular level reports. As to performance, I am not sure because I havn't...