Member Avatar for amitshrivas

Hello All
i have a query on (Union all) clause
i want to create a table through union clause.
the code i am trying to execute is:

select * into table1 from (select * from partmst union all select * from importexcel) as mytemp

but it shows error

Server: Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict for column 3 in SELECT INTO statement.

what should i do :( please help me i want to create it ASAP..

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Mohtshm
Member Avatar for Mohtshm

it is saying that column type for 3 column mismatch because the table from which you are selecting collating type is different
for this right click on table and check their collating type as well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.