Hi Trout,

wondering if you ever found a solution for this?

thanks

I have been told that using TT is more efficient than using TV when building dynamic TSQL queries, does anyone have any opinions on the validity of this statement?

thanks

I used Popkin's System Architect in college. It will help with ERDs, DFDs, context diagrams etc. They have a free trial download. not usre how costly the full blown product...

table a

ID column (pk)

2

table b

ID(pk) AID(fk) name

1 2 ba

2 ...

I believe you are going to need to declare the table variable & fields before you can reference it. Not like a temp table that you can delcare and populate...

Jay,

I am trying to compare a varchar field for values that do not exist in either a desc field or full desc field. It is intended to see how much...

Thanks Michelle !!

I understand the length criteria for varchar,

I do not understand how length relates to text data types.

thanks