Search results for query: *

I all depends on your app server connection pooling capability. Sometimes joins takes more resource because it has to traverse through three tables to come back with the result set but in the case of three queries..the only drawback is it has to connect to get the results...

Thanks rac2...

Thanks rac2 again.. But that will return all the rows that are acknowledged. I need the count for all under documents sent and count of those documents acknowledged under documents acknowledged.

Thanks for the reply, I forgot to add one more condition. The acknowledged count should be only for the documents that are acknowledgemed say status is "01"...

hi- I am trying an SQL but couldn't achieve with a query, any help will be highly appreciated. There are two tables say Table A and B A(col1, Qual, ID, ref) B(col1,(FK to Col1 on A) type of transaction, Date of transaction, Status of transaction, date of acknowledgement) Now I...

Hi- You can use the function timestampdiff.

Hi- You can use the function timestaffdiff.