Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 675
  • Last Modified:

Data table relation with two different data types

Trying to add a relation for two different data tables that the releated columns have different data types.

Both columns have the name of screen_no but one table is Int16 and the other is Int32.
I am getting the error "Parent Columns and Child Columns don't have type-matching columns"

Thanks,
0
DowntownIT
Asked:
DowntownIT
  • 3
1 Solution
 
Anurag ThakurTechnical ManagerCommented:
wont work
even sql server does not allow that
promote int 16 column to int 32 because in that way you wont be loosing anything
0
 
DowntownITAuthor Commented:
Thanks raqi, unfortunately I don't have control of the source of the columns but can change anything in the data table(s) as needed and that is where I am getting hung up. Don't know the best approach to doing that.

Thanks again,
0
 
DowntownITAuthor Commented:
I was able to do something completely different and bypassed this issue all together.
0
 
DowntownITAuthor Commented:
Went in a different direction
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now