SELECT DISTINCT RMTables.Tablename,RMDataset_Tables.DataSet_ID FROM RMTables,RMDataset_Tables WHERE RMTables.Table_ID=RMDataset_Tables.Table_ID AND RMDataset_Tables.DataSet_ID='#txtDataset_ID#' ORDER by RMDataset_Tables.Dataset_ID

SELECT sys.all_columns.name,type_name(user_type_id) datatype FROM sys.sysobjects ,sys.all_columns WHERE sys.sysobjects.name='#qryDatasetInfo.TableName#' and sys.sysobjects.id =sys.all_columns .object_id and sys.all_columns.name not like '%_ID' ORDER BY column_id

#qryDatasetInfo.TableName#

Select All /Deselect All

#qryColumns.Name#