troubleshooting Question

Collation Conflit

Avatar of mnmorency
mnmorency asked on
Web Servers
5 Comments1 Solution364 ViewsLast Modified:
I have run into this problem multiple times now and cannot figure out why (I think it may be SQL related).  I have two data sources used by ColdFusion.  Each connects to a different database, but the table structure of the two databases is exactly the same.  When I added the line of code used to generate the field "overrideqty"  I get an error message that says "[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot resolve collation conflict for equal to operation."  However, when adding the same line to the other data source, it works just fine.  I have attached the SQL code below.  Any help would be appreciated.  Thanks.

      SELECT
            ioh.[Location Code] AS LOCNCODE,
            loc.[Name] AS LOCNDESC,
            i.No_ AS ITEMNMBR,
            i.[Description 2] AS ITEMDESC,
            i.[Item Category Code] AS CATEGORY,
            cast(0 as int) as uskusF,
            cast(0 as int) as uskusQ,
            cast(0 as int) as uwip,
            cast(0 as int) as gskus,
            cast(0 as int) as gskusq,
            cast(0 as int) as gskust,
            kskus = case when ioh.[Location Code] = '001' then cast(SUM(ioh.[Remaining Quantity]) as int) else cast(0 as int) end,
            kskusq = case when ioh.[Location Code] = '002' then cast(sum(ioh.[Remaining Quantity]) as int) else cast(0 as int) end,
            cast(0 as numeric(18,2)) as zerovalue,
            (select top 1 qty from supersonics.vitals.dbo.opsinvdemandoverrides o where location = 'GmbH' and o.itemnmbr = i.No_ order by overrideid desc) as overrideqty
      FROM LMV.dbo.[LeMaitre Vascular K_K_$Item Ledger Entry] ioh INNER JOIN LMV.dbo.[LeMaitre Vascular K_K_$Item] i ON ioh.[Item No_] = i.No_ inner join LMV.dbo.[LeMaitre Vascular K_K_$Location] loc on ioh.[Location Code] = loc.Code
      WHERE ioh.[Location Code] in ('001', '002')
      group by
            ioh.[Location Code],
            loc.[Name],
            i.No_,
            i.[Description 2],
            i.[Item Category Code]
ASKER CERTIFIED SOLUTION
RCorfman

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros