Dynamic to static query conversion

Question

Hi,

 

Can you please convert and tell me the static query of the below

strSQL = " select t1.empId, t1.name , t1.updated, "
strSQL = strSQL & " t2.address, t2.description "
strSQL = strSQL & " from Test t1(nolock) "
strSQL = strSQL & " inner join Test2 t2(nolock) on t1.empId = t2.empId"
If IsValue(empId) Then strCond = strCond & " and t1.empId= " & CheckNull(empId, False)
If IsValue(name) Then strCond = strCond & " and t1.name= " & CheckNull(name, False)
If strCond <> "" Then
strCond = " where " & Replace(strCond, "and", "", 1, 1, vbTextCompare)
End If
strSQL = strSQL & strCond

Thanks

Sathish