Link to home
Start Free TrialLog in
Avatar of awilderbeast
awilderbeastFlag for United Kingdom of Great Britain and Northern Ireland

asked on

convert sql query to stored procedure

Hi all,

can someone convert this SQL Query into a stored procedure for me please, i learn best by working on comparison from what i have to what i want

Thanks

SELECT tblUsers.*, q.AssetCount
FROM
tblUsers LEFT JOIN
(
SELECT UserID, Count(tblEquipment.ID) as AssetCount FROM tblEquipment LEFT JOIN tblUsers ON tblEquipment.UserID = tblUsers.ID GROUP BY UserID 
) q
ON tblUsers.ID = q.UserID

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Cluskitt
Cluskitt
Flag of Portugal image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sachitjain
sachitjain
Flag of India image
create procedure Proc1
as
begin
      SELECT tblUsers.*, q.AssetCount
      FROM
      tblUsers LEFT JOIN
      (
            SELECT UserID, Count(tblEquipment.ID) as AssetCount FROM tblEquipment LEFT JOIN tblUsers ON tblEquipment.UserID = tblUsers.ID GROUP BY UserID
      ) q
      ON tblUsers.ID = q.UserID
end
Avatar of awilderbeast
awilderbeast
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

yeah i figured it out, quite simple really!

Thanks