slq procedure

[jayson1988]

Could someone help me with my code. It didn't work and i don't know why !!

ALTER PROCEDURE GetEnterprisePackage
@enterpriseID int,
@cultureID varchar
AS

SELECT Packages.*
FROM Packages AS packL1
INNER JOIN PackagesLocale ON Packages.PackageID = PackagesLocale.PackageID
INNER JOIN Enterprise_Package ON Packages.PackageID = Enterprise_Packages.PackageID
WHERE Enterprise_Package.EntepriseID = @enterpriseID
AND PackagesLocale.CultureID = (
SELECT packL2.CultureID
FROM PackagesLocale AS packL2
WHERE packL2.PackageID = packL1.PackageID
AND (packL2.CultureID = @cultureID OR packL2.CultureID = "")
ORDER BY packL2.CultureID DESC
)