bubs, look at how i changed your table definitions below.

/*

drop table PeerReview

drop table MasterReview

*/

CREATE TABLE [dbo].[MasterReview](

[ID] [int] IDENTITY(1,1) NOT NULL primary key,

[PerformanceID] [int] NOT NULL,

[SkillsGroupID] [int] NOT NULL,

[SkillsHeadingID] [int] NOT...

For the delete, make MasterReviewID on PeerReview reference MasterReview with a cascading delete.

But for the insert, I don't quite get it...what values will you use in the PeerReview when inserting...

Brings up an interesting question: why are the extensions MDB...

Tallboy (10/20/2011)

---

In the past when I was using MS Access as both FE and BE with linked tables I just let the users see all the records at once, but...

Apparently so:

http://msdn.microsoft.com/en-us/library/ms165629(v=sql.90).aspx

Post the trigger code so we can take a look.

It filters out rows with non-blank oder_id values. RTRIM and LTRIM simply remove spaces from a string on the...

So what is the error?

I knew I had this working properly at one time...my memory isn't what I remember it used to be. :w00t:

Include the commas in the string, like so:

declare @Codes varchar(25) =...

The OP didn't give the data type of table_Type_Codes, so I worked my example as it being a varchar. But it's a simple adjustment if the column is an int.

create...

Here is a second option. Will not be as performant as the splitter option.

Declare @Type_Code varchar(50)

set @Type_Code = '4,11,12'

Select * from table_Type_Codes Where @Type_Code like '%' + table_Type_Codes +...

Nice solution, Drew. Very smooth.

OP, if you want the extra non-matches to not show, thrown a WHERE n.Name IS NOT NULL

AND s.Code IS NOT NULL; to the end of...

What is your criteria for determining which code goes to which name?

I didn't think about it at first, but calculating the time like "where DATEPART(hour,(DateTested)) between 7 AND 16;" won't work. Use something like "where CAST(DateTested as Time) between '07:00' AND...

Not sure why you're doing an aggregate or a group by or one query...if you want the data separated into 3 temp tables, then copy them into 3 temp tables....