Using classic ASP/MS SQL 2008
I am trying to create a simple stored procedure for reports. I want it to return the results so that I can display them on a table, this is what I did, but nothing is returned :#
I need to results to be returned along with the total of records as well.
/****** Object: StoredProcedure [dbo].[rp_contacts_01_results] Script Date: 03/23/2015 09:46:03 ******/
SET ANSI_NULLS OFF
SET QUOTED_IDENTIFIER OFF
CREATE PROCEDURE [dbo].[rp_contacts_01_results]
SELECT a.UserId ,
FROM Users a
LEFT JOIN Users AS b ON a.EmployerId = b.UserId
WHERE a.UserType = 'corpuser'
ORDER BY b.MaidenNm ,
I am using Dreamweaver to run the command, but none of the results are showing up. It only works if I do a recordset with a query on the page in which case I cant use a stored procedure :(