jeudi 29 mars 2007

Select 'UPDATE ' + T.TAble_Name + ' SET ' + TF.Field_Name + ' = 0 where ' + TF.Field_Name + ' IS NULL'
From  Table_Fields TF
INNER JOIN Data_dictionary DD ON TF.dictionary_Id = DD.Data_dictionary_Id and DD.Type = 6
INNER JOIN Tables T ON T.TAbles_Id = TF.Tables_Id
INNER JOIN NG_Form_Field FLD ON FLD.Field_Id = TF.Table_Fields_Id
INNER JOIN NG_FORM_SEGMENT SEG ON SEG.NG_FORM_SEGMENT_ID = FLD.FORM_SEGMENT_ID
INNER JOIN NG_FORM F ON F.NG_FORM_Id = SEG.NG_FORM_ID AND NG_FORM_Name like 'EL%'
Where Default_Formula IS Null

Aucun commentaire: