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 |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2009-09-01 : 08:21:46
|
HiIn excel i have data like this...$250 +: $39$250 +: $39$250 +: $39$39 $39 $39 $39 $39 while import the data from excel to table...If the datatype money i will get below only$39 $39 $39 $39 $39 If the datatype money i will got below only$250 +: $39$250 +: $39$250 +: $39so please help on this...how i need both in single column i tried all datatypes... |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-09-01 : 08:39:19
|
quote:
If the datatype money i will get below only$39 $39 $39 $39 $39 If the datatype money i will got below only$250 +: $39$250 +: $39$250 +: $39
Not sure what do you mean?  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-01 : 09:02:06
|
| I think you need to have varchar datatype in the tableMadhivananFailing to plan is Planning to fail |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-01 : 10:54:35
|
And I think the OP should explain more clear...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Help