locked
date convertion Problem for exicuting RRS feed

  • Question

  •  i ma facing the Problem when date conversion  at run time

    set @p =( select MAX ( SandS_TUserRegform_pkID ) from SandS_TUserRegform1 )

    set @cdate = CONVERT ( date <script><!-- D(["mb","\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@cheq_date\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cWBR\u003e)\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003e\u003c/p\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eselect\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e @ptransname\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003d\u003c/font\u003e\u003c/font\u003e\u003cfont color\u003d\"#ff0000\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#ff0000\" size\u003d\"2\"\u003e\u0026#39;MyTransaction\u0026#39;\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003e\u003c/p\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eBEGIN\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e \u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eTRAN\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e @pTransname\n\u003cp\u003e\u003c/p\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#008000\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#008000\" size\u003d\"2\"\u003e--set @ddate\u003dCURRENT_TIMES TAMP\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003e\u003c/p\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eset\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e @cdate\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003d\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@cheq_date\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eExec\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e UserRegform_SPIns\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e \u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eSandS_TUserRegform_FirstName\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eS\u003cWBR\u003eandS_TUserRegform_SurName\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eSand\u003cWBR\u003eS_TUserRegform_MartialStatus\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eS\u003cWBR\u003eandS_TUserRegform_Gender\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eSandS\u003cWBR\u003e_TUserRegform_DOB\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eSandS_\u003cWBR\u003eTUserRegform_ContactNumber",1] ); //--></script> , @cheq_date ) select @ptransname = 'MyTransaction'

    BEGIN TRAN @pTransname

    --set @ddate=CURRENT_TIMES TAMP

    set @cdate = @cheq_date

    Exec UserRegform_SPIns SandS_TUserRegform_FirstName , SandS_TUserRegform_SurName , SandS_TUserRegform_MartialStatus , SandS_TUserRegform_Gender , SandS_TUserRegform_DOB , SandS_TUserRegform_ContactNumber <script><!-- D(["mb","\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003eSan\u003cWBR\u003edS_TUserRegform_Occupation\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003epFl\u003cWBR\u003eag\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@pMsg\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@regid\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e;\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e \n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#008000\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#008000\" size\u003d\"2\"\u003e--set @regid\u003d@p\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eset\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e @p\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003d\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@p\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e+\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e1\n\u003cp\u003e\u003c/p\u003e\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003eset\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e @p\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003d\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e@regid\n\u003cp\u003e\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003einsert\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e \u003c/font\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#0000ff\" size\u003d\"2\"\u003einto\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e SandS_TUserDepositDetails\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e(\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003eSandS_TUserRegform_pkID\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003eSandS_TUserDepositDetails_\u003cWBR\u003eSpecOffer\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003eSandS_TUserDepositDetails_\u003cWBR\u003eAmount\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e,\u003c/font\u003e\u003c/font\u003e\u003cfont size\u003d\"2\"\u003e\n\u003cp\u003eSandS_TUserDepositDetails_\u003cWBR\u003eCashCardType\u003c/p\u003e\u003c/font\u003e\u003cfont color\u003d\"#808080\" size\u003d\"2\"\u003e",1] ); //--></script> , SandS_TUserRegform_Occupation , pFlag , @pMsg , @regid ;

    --set @regid=@p

    set @p = @p + 1

    set @p = @regid

    insert into SandS_TUserDepositDetails

    values ( @regid , @offer , @deposit_amount , @cashcardtype , @deposittype , @cheq_date , @bankname , '09/08/2000' );

    Thursday, October 14, 2010 9:40 AM