Sorting DataGrid with Stored Procedure 1

[suicidaltendencies]

Here is my stored procedure. What is wrong with it I'm getting an error on line 6.

Thanks,
Harold

CREATE PROCEDURE getCustomers(@OwnerID varchar(50), @SortFieldName varchar(50)) AS

DECLARE @SQLStatement varchar(1000)

SELECT @SQLStatement = 'SELECT Customers.CustomerID, Customers.Password, Customers.FirstName, Customers.LastName, Customers.Notes,' +
'Customers.Email, Customers.Cell, Customers.Phone, Customers.Zip, Customers.State, Customers.City, ' +
'Customers.Address, Owners.OwnerID' +
'FROM OwnerEmployee INNER JOIN' +
'Employees ON OwnerEmployee.EmployeeID = Employees.EmployeeID INNER JOIN' +
'Owners ON OwnerEmployee.OwnerID = Owners.OwnerID INNER JOIN' +
'EmployeeCustomer ON Employees.EmployeeID = EmployeeCustomer.EmployeeID INNER JOIN' +
' Customers ON EmployeeCustomer.CustomerID = Customers.CustomerID' +
'WHERE (Owners.OwnerID = @OwnerID) and (dbo.EmployeeCustomer.EmployeeID = @OwnerID) ORDER BY ' + @SortFieldName

EXEC(@SQLStatement)
GO

 

[LV]

There seems to be an error concatinating @OwnerID. Try it like this:

CREATE PROCEDURE getCustomers(@OwnerID varchar(50), @SortFieldName varchar(50)) AS

DECLARE @SQLStatement varchar(1000)

SELECT @SQLStatement = 'SELECT  Customers.CustomerID, Customers.Password, Customers.FirstName, Customers.LastName, Customers.Notes,' + 'Customers.Email, Customers.Cell, Customers.Phone, Customers.Zip, Customers.State, Customers.City, ' +'Customers.Address, Owners.OwnerID' + 'FROM OwnerEmployee INNER JOIN' + 'Employees ON OwnerEmployee.EmployeeID = Employees.EmployeeID INNER JOIN' + 'Owners ON OwnerEmployee.OwnerID = Owners.OwnerID INNER JOIN' + 'EmployeeCustomer ON Employees.EmployeeID = EmployeeCustomer.EmployeeID INNER JOIN' + ' Customers ON EmployeeCustomer.CustomerID = Customers.CustomerID' +

-- if Owners.OwnerID & Employees.EmployeeID fields are int:
'WHERE (Owners.OwnerID =' + @OwnerID + ') and (dbo.EmployeeCustomer.EmployeeID =' + @OwnerID + 

-- if Owners.OwnerID & Employees.EmployeeID fields are char/varchar:
'WHERE (Owners.OwnerID =''' + @OwnerID + ''') and(dbo.EmployeeCustomer.EmployeeID =''' + @OwnerID + 

''') ORDER BY  ' + @SortFieldName

EXEC(@SQLStatement)