filament-panels::layout.skip_to_content.label
trạng thái
production

Lấy Segment

Người tạo: superadmin Cập nhật 1 ngày trước 

SELECT Item_Id,
		Item_Code Ma, 
		Item_Name Ten,
		Item_Long_Name TenDayDu,
		Category_Code,
		(SELECT TOP 1 dm.TenDoiTuong FROM dbo.IN00003_Spit(Category_Code ,'.') a
		JOIN dbo.DM_Lookup dm ON dm.MaDoiTuong = a.DUAN AND dm.MaLook = 'INV_CATE_SEG01'
		WHERE a.STT = 2) AS SEG01,
		(SELECT TOP 1 dm.TenDoiTuong FROM dbo.IN00003_Spit(Category_Code ,'.') a
		JOIN dbo.DM_Lookup dm ON dm.MaDoiTuong = a.DUAN AND dm.MaLook = 'INV_CATE_SEG02'
		WHERE a.STT = 3) AS SEG02,
		(SELECT TOP 1 dm.TenDoiTuong FROM dbo.IN00003_Spit(Category_Code ,'.') a
		JOIN dbo.DM_Lookup dm ON dm.MaDoiTuong = a.DUAN AND dm.MaLook = 'INV_CATE_SEG03'
		WHERE a.STT = 4) AS SEG03
FROM dbo.Inv_Items
WHERE Item_Code LIKE '%A2%'