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 |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2007-10-05 : 11:07:21
|
| i have a SP which creates a physical tableINSERT INTO dbo.Weekly_Term_Code_History (Date_From, Date_To, app_id, term_code, calls, errors)SELECT #History_Vol.Date_From, #History_Vol.Date_To, #History_Vol.app_id, #History_Vol.term_code, cast(#History_Vol.Volume as int), cast(#History_Range.Out_Range as int)FROM #History_Vol INNER JOIN #History_Range ON #History_Vol.Date_From = #History_Range.Date_From AND #History_Vol.Date_To = #History_Range.Date_To AND #History_Vol.app_id = #History_Range.app_id AND #History_Vol.term_code = #History_Range.term_codethe table the data is appended to has an data type INT for calls and vols but when i export to excel i get a ' at the begining of the numerical value which indicates a text value. How can i correct this? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:07:54
|
| How did you export data to excel? |
 |
|
|
|
|
|
numerical excel export