Thank You both very much

love the signatures...lol "A lack of planning on your part does not constitute and emergency on mine!" <-- I have that same sticker behind my...

above is the index, below is the structure

would you like DDL as...

im sorry, it still is not working and i dont know what to do...

can you take another look or point me in the right direction?  I would like to figure...

Still kind of stuck, it has to be something simple i am not doing correctly.

USE [SCX_3215]

GO

/****** Object:  StoredProcedure [dbo].[search]    Script Date: 09/18/2007 15:42:43 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[search]

(

 @ittNumber...

hi again,  thank you for the explanation.  I understand what you are doing and it makes sense, but somethihng is not adding up.  when i run this as a SP...

Hi brandie

thanks for the prompt response.  Yes, it has full-text capabilities and i selected the table and columns that i want searchable with the runtime late at night every night....

such a newbie mistake! I got it though.  Basically, in the table tblfltwrkcntr, there was a column called wrkcntrID that SHOULD have been in numerical order but there were old...

well, that kind of sucks.  how do you bump a thread without blatantly bumping it?? Maybe i will just keep posting updates...and hopefully i get it by then.

Thanks

The data in the tblassignment field is there for one reason.  When a new workcenter gets assigned a requirement, so the data i posted was the first row in each...

LOl, when i said "table i presume" i meant i am assuming that you are talking about the letter t standing for tables.  i (I) should have stated "I  Presume...

Still a little unsure;

I understand this:

SELECT DISTINCT

  t.ittnumber

 ,t.itttitle

 ,t.daterequired

The t stands for table i presume in this case?

This is where i am not understanding:  Why the...

ken, none taken and i apologize.  I have not had too much luck with people explaining what they want so far.

when you say " Your INSERT statements for tbl3215...

thanks Sir,

I have had a rough day, i think the melon on my head is growing from banging it off the desk too many times

Maybe i thought the DDL i posted WAS correct, since afterall i did ask in the third post of this thread.  I was instructed to do it as an insert statement. ...

maybe this will help

here is the SCMC row from tblfltwrkcntr

here is an SCB

another thing that i found is it appears that under the columns under fltwrkcntrID are out...