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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-21 : 06:40:22
|
| thanksfor help writes "Hi,I need help in this small convert and cast errorDECLARE @P AS intDECLARE @S AS int SET @P = 3SET @S = 0exec('SELECT CONVERT(DECIMAL(' +cast( @P as varchar) + ',' + cast(@S as varchar) + '), RTRIM(LTRIM(''123.3'')))') I am getting "Incorrect syntax near 'cast'".Thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
convert and cast issue in dynamic sql 