Forum Replies Created

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

  • RE: Dyamic SQL Cursor is not working in SQL 2008

    HI,

    This is the complete working Procedure.I manage to run the full procedure successfully.

    ALTER PROCEDURE [dbo].[usp_InsertIntoTable]

    (

    @Table_Name VARCHAR(70),

    @Column_Name VARCHAR(70)

    )

    AS

    DECLARE @strSQl VARCHAR(4000)

    DECLARE @DateValue VARCHAR(20)

    DECLARE @Value VARCHAR(20)

    DECLARE @sqlstatement nvarchar(MAX)

    DECLARE @InsideSQl nvarchar(MAX)

    DECLARE @getData...

  • RE: Dyamic SQL Cursor is not working in SQL 2008

    HI,

    Below are the Process which i m doing inside the cursor.Hope this will help you to give me a better solution.

    OPEN @getData

    FETCH NEXT FROM @getData INTO @DateValue,@Value

    WHILE @@FETCH_STATUS = 0

    BEGIN

    --Checking...

  • RE: Dyamic SQL Cursor is not working in SQL 2008

    HI ,

    Thanks for your quick reply.

    Insert and update part i removed from the script for Time being.

    Can you give me an example script or some useful links to run...

  • RE: Dyamic SQL Cursor is not working in SQL 2008

    HI,

    Thanks for your quick reply.

    Well,Let me explain the complete scenario.

    Here what i m trying to do is i am passing the Table name and column name to the procedure ,then...

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