Post reply

DTS stored procedure

  • May 2, 2007 at 10:24 am

    #72813

    r

    uyirurii

    Kindest Regards,

    Web programmer

  • May 3, 2007 at 9:11 am

    #704109

    Your variable @intCompanyID is declared as INT - you can't mix this with VARCHAR when concatenating arguments.

    Change WHERE intCompanyId = ' + @intCompanyID to WHERE intCompanyId = ' + CAST(@intCompanyID AS VARCHAR).


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply