Link Unit

Wednesday, August 24, 2005

I am looking for the development of a reporting tool (something like Crystal Reports). Can someone provide links and material which will help me in developing this tool. I wish to use SQL Standards for the queries that will be generated intermediately , so no cube , rollup

insert into JTrial(XYZ) values(1)insert into JTrial(XYZ) values(2)insert into JTrial(XYZ) values(3)insert into JTrial(XYZ) values(4)select * from JTrialIs there any better alternative.Check constraint like this check ( d = convert(varchar,d,112) ) Will not allow me to insert row insert into JTrial(XYZ,d) values(5,getdate()) -- Because here date has time partIs writing A trigger better alternative ?