thanks!!

🙂

thanks for clarifying. I have used CURSORS where I only work...

would a CURSOR for each row in tblGroups not work, or is that a bit overkill?

if you only need data from table A, why not use a DISTINCT and only select values from table A?

SELECT DISTINCT _TOPICS.ID, _TOPICS.TITLE

FROM _TOPICS

RIGHT OUTER JOIN _THREAD

ON _TOPICS.TITLE =...

Hi

Do you have access to the Management Studio? If you do, you can reset it by going to Security -> Logins

then right click properties on the sa account and change...

yip, I made it varchar(320)

also going through the other bib tables to make sure there aren't other unnecessary uses of text fields

wow! the average size is 90-120 chars with the max being 290 chars, why would they have made it a text field.

anyways, will run the ALTER TABLE statement when everyone...

that makes sense, didn't think of that.

They can be quite long, but I doubt it is that large, the table is part of a legacy system developed yonks ago. Will...

Thanks Gila, I was on the right path then, just needed some confirmation.

my index I created looks like this:

CREATE INDEX idx_PC ON nbs_sa_4740 (NBSPC)

INCLUDE (ISBN13, TL)

thanks

[ISBN13] [varchar](13)

[TP] [varchar](9)

[TL] [text]

[NBSPC] [varchar](50)

[RPG] [varchar](200)

The field in question is the NBSPC field.