none
declare dan isnull RRS feed

  • Pertanyaan

  • <ASK> selamat siang para suhu,  membuat stored procedure

    menggunakan fungssi declare dan isnull 

    declare @tglmulaiijin VARCHAR (20),
    @tglakhirijin VARCHAR (20)

    set @tglmulaiijin =ISNULL((select TGL_MULAI from IJIN where USERID = @userid),'') 
    set @tglakhirijin =ISNULL((select TGL_AKHIR from IJIN where USERID = @userid),'')

    ketika di exec terjadi kesalahan 

    Msg 512, Level 16, State 1, Procedure REKAP_ABS, Line 12
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
    Msg 512, Level 16, State 1, Procedure REKAP_ABS, Line 13
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    mohon arahan para suhu

    terima kasih

    Kamis, 07 Februari 2019 03.57