daily pastebin goal
37%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 257 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT <columns>
  2. FROM [DatabaseA].[Sales_Forecast], [DatabaseB].[Customers]
  3. ORDER BY [DatabaseB].[Customer_ID];
  4.    
  5. Cannot resolve the collation conflict between "Latin1_General_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
  6.    
  7. SELECT <columns>
  8. FROM [DatabaseA].[Sales_Forecast] sf
  9.     JOIN [DatabaseB].[Customers] c
  10.         ON sf.[Customer_ID] = c.[Customer_ID]
  11. ORDER BY c.[Customer_ID];
  12.    
  13. SELECT <columns>
  14. FROM [DatabaseA].[Sales_Forecast] sf
  15.     JOIN [DatabaseB].[Customers] c
  16.         ON sf.[Customer_ID] COLLATE Latin1_General_CI_AS = c.[Customer_ID] COLLATE Latin1_General_CI_AS
  17. ORDER BY c.[Customer_ID]
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top