Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2013
    Posts
    21

    Unanswered: can some1 help me to resolve problem with query

    when i try to run this query against sql server throws me an error .
    can anybody help out with this.




    from r5gridparam inner join r5grid a
    on a.grd_gridid = gdp_gridid
    left outer join ((r5grid b inner join r5gridfield on b.grd_gridid = gfd_gridid and gfd_occurrence = 1)
    inner join r5boilertexts on gfd_botfunction = bot_function
    and gfd_botnumber = bot_number
    and bot_lang = @parameter.language) on gfd_tagname = gdp_tagname and b.grd_gridname = (case when charindex('_',a.grd_gridname) > 0 then substring(a.grd_gridname, 1, charindex('_',a.grd_gridname)-1) else a.grd_gridname end) where a.grd_gridid = @param.gridid


    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I bet we can help. What is the error that SQL Server throws?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2013
    Posts
    21
    @patp


    Error converting data type varchar to numeric.


    Thanks!

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm not certain, but my guess is that @parameter.language is probably not a validly formatted numeric string.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •