Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Dynamic Insert and Update...

    That was the key!!! What exactly does the "N" do anyway so i can LEARN to fish instead of ASKING for fish? 🙂

    Thanks,

    Rich

  • RE: Dynamic Insert and Update...

    Hmm, now I'm getting this error about the sp_executesql line...

    Server: Msg 214, Level 16, State 3, Procedure sp_executesql, Line 25

    Procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'.

  • RE: Dynamic Insert and Update...

    This didn't seem to work 🙁

    CREATE PROCEDURE usp_InsertAnswersAboutThem

    @TableName varchar(100),

    @ColumnName varchar(100),

    @MemberID int,

    @AnswerID int

    AS

    DECLARE @FindMember varchar (1000)

    DECLARE @FindAnswer varchar (1000)

    DECLARE @DoInsert varchar (1000)

    DECLARE @DoUpdate varchar (1000)

    DECLARE @VarCompare1...

Viewing 3 posts - 1 through 4 (of 4 total)