Need a Help on build script

[dr.murthy]

Hi all,

i have an requirement like to bulid a one script for validating fileds in all tablesby with below syntax..

----<FILELD_NAME>
INSERT INTO VALIDATION
SELECT CASE WHEN (select count(*) from <TABLE_NAME> where <FILELD_NAME>is not null and
<FILELD_NAME>>' ') > 0 THEN 'PASS' ELSE 'FAIL' END"RESULT",0,GETDATE() GO

my thing is i have an 87 tables in my datamart and more than 7000 fileds and i have a sheet which contains tablenames and field names.
is there any possibility to by doing automation for bulld a script

Thanks in Advance...

[Sainath.Srinivasan]

Your syntax appears to denote SQL Server.

You can use something like @sp_columns to identify list of columns and iterate through it.