Post reply

Table Value Funcation Not Working

  • August 24, 2011 at 9:01 am

    #243737

    Hi

    In One My of Database "Table Value Function" is not working properly what factor can i check.

    the same copy of backup is restored another database .it is working properly.

    how can i check that one

    at what factore it may be consuming

  • August 24, 2011 at 9:04 am

    #1372649

    "not working properly" is really tough to diagnose without seeing the function itself,as well as how you are calling the function.

    do you mean it doesn't return the expected results? wrong results? no data? returns an error? are you giving the procedure parameters? are they correct? are they NULL?

    help us help you! give us CREATE TABLE, CREATE FUNCTIOn and INSERT INTO...statements so we can duplidate whatever you are testing ourselves; we can then offer tested solutions and concrete advice.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 24, 2011 at 9:07 am

    #1372653

    i am passing two parametres start date and end date

    it will creating temporay table and generating result one

  • August 24, 2011 at 9:08 am

    #1372654

    Div Goud (8/24/2011)

    i am passing two parametres start date and end date

    it will creating temporay table and generating result one

    well, a function can only create a table variable, and cannot create a temp table...maybe you want to show us the actual function you've got so far?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 24, 2011 at 9:10 am

    #1372656

    yaa its creating table varibe only

  • August 24, 2011 at 9:14 am

    #1372659

    --Cursor to check with all other records

    While @@fetch_status=0

    Begin

    Set @cnt = @cnt-1

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

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