[dba-VB] Listing distinct values in field

Susan Harkins ssharkins at gmail.com
Mon Dec 3 13:11:53 CST 2007


Well, for the meta data, I'll check out schema recordsets. I know that T-SQL 
can produce a unique sort, but off the top of my head, I don't remember the 
keyword.

Susan H.


> In my client's business he needs a "data dictionary" kind of thing which
> essentially tells him the valid values in any given field (for WHERE 
> clause
> purposes).  I receive CSV and fixed width files which I import into SQL
> Server.  I need to give him a list of the fields and the valid values in
> each field (actual different data items).  I will be writing such a widget
> if I can't find one already out there.
>
> Does anyone have such a widget or know where to find one?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 




More information about the dba-VB mailing list