Ken, interesting.  It partially worked but only for one workcenter.

We have another section called SCM, with subsections

SCM

   SCMC (this works)

   SCMPO (does Not)

   SCMP (does Not)

  SCMCI (does Not)

SCB

   SCBM...

all, i think i have identified the issue.  Now i ask for your help how to solve it.

within each 3 letter designator there is a sub org if you...

ok ken, i tried that and it appears to do the same thing as this one

select distinct dbo.tbl3215.ittnumber, dbo.tbl3215.itttitle, dbo.tbl3215.daterequired from dbo.tblassignment inner join dbo.tbl3215 on dbo.tbl3215.ittnumber = dbo.tblassignment.ittnumber inner...

in all honesty i never knew you could do that...

i will try it tomorrow at work at let you know.

thanks for the tip

Hi Ken, thanks for the help.  I will try this tomorrow when i get into work.

You mentioned shortening nvarchar(max) columns....im sure there is a good reason, to increase data access...

Yes i tried that as well.

there is something that i am missing and i cant quite put my finger on it. I got it to work, but it does...

John, thanks for the kind response, some folks get in a tizzy

here you go:

DDL from tbl3215:

INSERT INTO [SCX_3215].[dbo].[tbl3215]

           ([id]

           ,[IttNumber]

           ,[IttTitle]

           ,[IttDescription]

           ,[IttJustification]

          ...

OK, newbie alert...what is DDL?