Hi all I have a table in which I save a record each time when a user checks in and checks out the office through a time in/ time out device(this device takes thumb impression of user, thus inserts record) table definition is as follows: checkInOutID (PK,int,not null) employeeID (FK, int, not null) isCheckIn...

I have a SP that I can run from QA, and command line with no issue. But for some reason it hangs when it's called from the APP. At first we thought it was a cache issue so I put WITH RECOMPILE in the SP. so we started a trace in it. We found the part that was having the issue. The issue is at a Link...

Hi all, How can i retrieve a record that starts with a particular number,say 5? Thanks In advance Jeen

Hi all, Im having two tables with 1 crores of record each. I want to avoid its duplication.But when im giving the query in query analyser for that.Its giving an error that,connection broken.Or sometimes in main window its giving time expired. What shoul i do for this. Kindly help me. Thank You. Jeen

Hi, I've tried the following query in SQL SERVER 2005, SQL Express and MACCESS. select * from Table1 where drid in (SELECT DrID FROM Table2 WHERE (substring(PostalCode,1,3) IN ('B0E','B1P','B2H','B2Y','B3A','B3M','B4A','B4H','E1A'...

Try this query select e.empname,s.empsal,d.deptname from emp e,empsal s,dept d order by empsal Thanks Jeena

I need a query for the following Tables [Emp] [Dept] [EmpDept] [EmpSalary] ===== ===== ======== ========= EmpID DeptID EmpID EmpID EmpNM DeptNm DeptID EmpSalary Find a query to find out all the employees who had the maximum salary (if more than one have same max salary show each of them) for each Department...

I need to select many ( around 15 columns) from 4 tables and arrange them in an order ( that i need). Some of these tables have the same column name, and other different one had tried many queries, but of no use. could any one suggest a query??