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 |
|
jdub_92
Starting Member
13 Posts |
 Posted - 2008-10-17 : 05:57:22
|
| Hi everyone,Can you help me with my sql query?I want to create two temp table wherein i will dump data from a sql table then compare its columns dataype to another column datatypes of another temp table wherein also i will dump a data from other sql table.any idea?Thanks,jwill |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-17 : 06:01:39
|
| Could'nt get you.Why do you need temp tables and data to compare only the datatypes of columns?Planning replaces chance by mistake |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 06:08:36
|
| are you trying to see the values present and then covert it to some other type? please explain your scenario? |
|
|
|
jdub_92
Starting Member
13 Posts |
Posted - 2008-10-17 : 11:39:20
|
| actually these tables are from sharepoint list columnsi have two sharepoint listfirst sharepoint list(listA) have different columns with different datatypes, there are 40 columns in this list overall.ex. text, date, lookup, choice, number, etc.the second shrepoint list(listB) also with different columns with diff datatypes, here there are 24 columnsex. text, date, etc.,what i want to do is get the column datatype match when i transfer listA to listB,. obviously listA columns is greater than listB, but thats not a prob, i will create another column for that excess,. sowhat i want to do now is identify which column has same datatype in listA with listB,.thats why im thinking of creating a temptable where in i can dump the data for those two lists and compare now,. im thinking of join table but dont know where to start., any idea???i will not convert any datatype for now,.i only want the matchthanks for the replyjwill |
|
|
|
|
|
|
|
|
Create temp table and compare datatypes