Ah, I just noticed....change the criteria for tablename to be a list of tablenames....either from sysobjects, or whereever......I had a tablelist of specific tables I referenced.....

This will get you foreign keys:

SELECT 'ForKey',

 child_table   child_table,

       obj.name      constraint_name,

       child_column  child_column,

       child_pos     pos,

       parent_table  parent_table,

       parent_column parent_column

  FROM (

       SELECT tab1.name child_table,

              col1.name child_column,

              CASE col1.colid

                 WHEN ref.fkey1 THEN...

There is a system table, unfortunately I've forgotten the name of it, but the proc text is held in the text field in this table, so long as it's not...

Select

A.WS_NUM, A.ComponentValue, A.auditid

From

testx A

Inner

...

It could be done by looping the records, but not in a single select.

This is one of the options I tried, and can tell you that the results are incorrect like this. Run the two statements together, and you'll see what I am...

It appears that you are looking for the minimum start date and maximum end date by item and price. If that is correct, then :

Select Item, Min(StartDate) as StartDate, Max(EndDate)...

Yes, not only can you do this, but If you create the same statements using the left outer join syntax, run both statements in the same query window and turn...