Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: Creating a View with Declare

    Hi

    I have a Query:

     

    DECLARE @baseQuery NVARCHAR(max)

    DECLARE @baseQueryFilterString NVARCHAR(max)

    DECLARE @bankTransferNoteQuery NVARCHAR(max)

    DECLARE @bankTransferNoteFilterString NVARCHAR(max)

    DECLARE @payableNotes NVARCHAR(max)

    DECLARE @payableNotesFilterString NVARCHAR(max)

    DECLARE @prePaidNotes NVARCHAR(max)

    DECLARE @bankAccountInfo NVARCHAR(max)

    DECLARE @bankAccountInfoFilterString NVARCHAR(max)

    DECLARE @orderByClause NVARCHAR(max) = ' Order By BankName,BankBranchName,BankAccountNumber'

    IF (null...

Viewing post 1 (of 1 total)