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.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2008-03-20 : 10:52:59
|
| Hi i have a table where the week number is held in it as a tiny int. I can't change this tables datatype.But i can change the lookup table coulmn as am using a an expresstion to create it. I'd like to know what datatype i can assign my new week_no column so it will join up with my other week_no column its currently set as a tinyint. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-20 : 10:54:04
|
| i think int would be fine. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-03-20 : 11:05:48
|
| Am working within a SSIS package and am using the data conversion task but i can't see any datatype for tinyint listed. I already tried int and it does not work. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2008-03-20 : 11:22:25
|
| I worked around it. I used the convert to convert my tinyint to a int and then used the single byte unsigned intenger. Thanks for your help. |
|
|
|
|
|
|
Datatype query