Select TUP.*,TUPI.Body,TUPI.Descriptions,TUPI.Keywords,TUPI.Name AS N'LangName',TUPI.SmallDesc From [dbo].[TUniqueProduct] TUP Left Join TUniqueProductItems TUPI On TUP.ProductID = TUPI.ProductPID where [ProductGuID] = @ProductGuID AND [CurrentCount] > 0 AND TUP.ShopID = @ShopID And Lang = @Lang
And (Lang = @Lang or Lang is null)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)