Hi,
I have a query called QryExtract as;
SELECT GPRDTech.gprdsql.TblPracDetails.prac_no, GPRDTech.gprdsql.TblPracDetails.practice_name, GPRDTech.gprdsql.TblPracDetails.prac_status,
dbo.TblPracExclude.prac_enabled
FROM GPRDTech.gprdsql.TblPracDetails LEFT OUTER JOIN
dbo.TblPracExclude ON GPRDTech.gprdsql.TblPracDetails.prac_no = dbo.TblPracExclude.prac_no
Results
prac_no Practice_name prac_status prac_enabled
1 A Active True
2 B Old False
3 C Active False
4 D Active NULL
Ok -
prac_no 1 = the practice is active and enabled
prac_no 2 = the practice is old and disabled
prac_no 3 = the practice is active but disabled
prac_no 4 = the practice is Active but has no status ( new practice)
The prac_enabled is updated from a form in VB.Net.
But as far as this query is concerened can I enforce all OLD practices to be set as FALSE.
Secondly, can I change any NULL value to TRUE by default.
Thanks
Insert Records
Posted - 06/12/2012 : 10:48:05
