Wednesday, April 24, 2024 7:54:57 AM
--one language
select S.Id,S.Name,S.DisplayOrder
from SpecificationAttribute S WITH (NOLOCK)
where S.Id in (select SpecificationAttributeId from #tmpSpecificationAttributeOption)
order by S.DisplayOrder
select SO.Id,SO.SpecificationAttributeId,SO.Name,SO.DisplayOrder
from SpecificationAttributeOption SO WITH (NOLOCK)
where SO.Id in (select Id from #tmpSpecificationAttributeOption)
order by SO.SpecificationAttributeId,SO.DisplayOrder
--one language
select S.Id,S.Name,S.DisplayOrder
from SpecificationAttribute S WITH (NOLOCK)
where S.Id in (select SpecificationAttributeId from #tmpSpecificationAttributeOption)
order by S.DisplayOrder
select SO.Id,SO.SpecificationAttributeId,SO.Name,SO.DisplayOrder
from SpecificationAttributeOption SO WITH (NOLOCK)
where SO.Id in (select Id from #tmpSpecificationAttributeOption)
order by SO.SpecificationAttributeId,SO.Name