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 |
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-07-22 : 01:06:49
|
hi this text get me errorselect*from (select convert(int,col001) as t1,convert(money,Col002)from cdma_e) as bir full join(select convert(int,Test ) as t2 ,convert(money,Test1)/100.0 from avans where convert(int,Test)>=4080000 and convert(int,Test)<=4099999) as iki on bir.t1=iki.t2---------Message 8155, Level 16, State 2, Line 1No column was specified for column 2 of 'bir'.kmkmmm |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-22 : 01:16:32
|
quote: Originally posted by pascal_jimi hi this text get me errorselect*from (select convert(int,col001) as t1,convert(money,Col002) as columname from cdma_e) as bir full join(select convert(int,Test ) as t2 ,convert(money,Test1)/100.0 from avans where convert(int,Test)>=4080000 and convert(int,Test)<=4099999) as iki on bir.t1=iki.t2---------Message 8155, Level 16, State 2, Line 1No column was specified for column 2 of 'bir'.kmkmmm
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-07-22 : 01:22:30
|
thank you very much visakhyou're excellent friendkmkmmm |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-22 : 01:41:11
|
you're we;come as always ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|