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 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2005-05-13 : 05:24:11
|
| Is there any limitation on the length of the query used? When the query exceeds 128 characters, I get the errorServer: Msg 103, Level 15, State 7, Line 1The identifier that starts with 'Select Id,Name,Descrip, Address, others, case when len((Select distinct Street from mydb..testw2 where w2' is too long. Maximum length is 128.MadhivananFailing to plan is Planning to fail |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-14 : 17:11:54
|
| Can you put the query in an SP and execute that is the bcp - will be a lot more flexible.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-16 : 01:02:52
|
| Yes, I already did that and workedMadhivananFailing to plan is Planning to fail |
|
|
|
tomy74
Starting Member
32 Posts |
Posted - 2005-05-16 : 04:26:53
|
| Hi,You can use a view and then bcp from it also.Thanks,Tarek G. |
|
|
|
|
|
|
bcp limitation