Union all Issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Union all Issues

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-07 : 09:50:38

I have View: CREATE VIEW [dbo].[view_info_t]
AS
select BUSINESS_UNIT,
DES[location],
HOME_DEPARTMENT[home_department],
M_FIRST_NAME[mgr_first_name],
MGR_LAST_NAME[mgr_last_name],
LAST_NAME[last_name],
FIRST_NAME[first_name],
REP[rep],
Delta_id[Delta],
STRE[stre]
from dbo.view_info_t
and a table with same column name as view

So i am using this command:
select* from table
union all
select* from west_employee_info_t[b]

but i am getting this error:
Implicit conversion of char value to char cannot be performed because the collation of the value is unresolved due to a collation conflict.

Can somebody help?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-07 : 09:57:39

Worked with COLLATE SQL_Latin1_General_CP1_CI_AS. Got it

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-07 : 09:59:12

It means character columns from both tables have different collations.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources