Database

Try<br />
   myDataAdapter.Fill(myDataTable)<br />
Catch ex As Exception<br />
   MessageBox.Show("Error: " & ex.Message)<br />
End Try

CREATE FUNCTION dbo.ConcatQualifications(@EmpId INT) RETURNS VARCHAR(200)
AS BEGIN
   DECLARE @Expertise VARCHAR(200), @Qualification VARCHAR(20)

   DECLARE c1 CURSOR LOCAL FAST_FORWARD FOR
      SELECT Qualification FROM Emp_Qualifications
      WHERE EmpId = @EmpId
      ORDER BY Qualification
   OPEN c1
   WHILE (@@FETCH_STATUS = 0) BEGIN
      FETCH c1 INTO @Qualification
      IF (@@FETCH_STATUS = 0) BEGIN
         SET @Expertise = IsNull(@Expertise + ', ', '') + @Qualification
      END
   END
   CLOSE c1

   RETURN @Expertise
END

SELECT Employee.empid, Employee.fname, Employee.lname, Employee.designation,
   Department.dept_name, dbo.ConcatQualifications(Employee.empid) Expertise
FROM Employee
INNER JOIN Department
ON Department.deptid = Employee.deptid
WHERE ####Your criteria goes here####
ORDER BY Employee.empid

The_Server wrote:

Does anyone know any good tutorials or books.

lavell wrote:

I am trying to return only the first 10 records in sql code that has a where clause. here is my current code. Any help is appreciated.