프로세스 메니저 right 함수 에러라고 뜰때  

 

멜티복스랑 뷰렉스 파일 결로가 틀려서 에러발생 

 

프로시저를 수정해주면됨.

 

봉화해성병원 참고할것..

 

 

 

 

USE [ViewRex]
GO
/****** Object:  StoredProcedure [dbo].[UDP_GetImages]    Script Date: 2019-04-26 오후 2:46:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[UDP_GetImages]
    @SeriesID int
   
AS
BEGIN
 SET NOCOUNT ON;
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
   
    SELECT A.oID           [ImageoID]
         , A.SeriesID      [SeriesID]
         , A.DisplaySeq    [DisplaySeq]
         , A.SOPInstanceUID   [SOPInstanceUID]
         , p.Path          [FileRootPath]
         , LEFT(A.[FileName], LEN(A.[FileName]) - CHARINDEX('\', REVERSE(A.[FileName]))) [FilePath]
         --, RIGHT(A.[FileName], CHARINDEX('\', REVERSE(A.[FileName])) - 1)        [FileName]
   , CASE WHEN B.OldPACSKey IS NULL THEN
   RIGHT(A.[FileName], CHARINDEX('\', REVERSE(A.[FileName])) - 1)
     ELSE
   ''
     END FILENAME
   , A.Width        [Width]
   , A.Height       [Height]
   , A.PixelWidth       [PixelWidth]
   , A.PixelHeight      [PixelHeight]
   , A.BytesPerPixel      [BytesPerPixel]
   , A.PlaneLocation      [PlaneLocation]
   , A.SliceThickness      [SliceThickness]
   , A.FrameOfReferenceUid    [FrameOfReferenceUid]
   , A.FrameCount       [FrameCount]
   , A.ImageTime        [ImageTime]
    FROM [Image] A
    INNER JOIN Series B ON A.SeriesID = B.oID
 INNER JOIN PathAlias p ON A.AliasName = p.AliasName
    WHERE B.oID = @SeriesID
      AND A.Removed = 0
    ORDER BY A.DisplaySeq
   
    SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
   
END
 
GO

오늘:
0
어제:
0
전체:
0