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 - 2002-07-26 : 09:39:26
|
| bobby writes "I can get this query to work using the sql query analyzer but when using msquery with microsoft excel, it returns no results. Any cluse as to why?select ir.sran, ir.[stock number], ir.[serviceable balance]as [o/h qty], ir.errcd, ir.[iex code] as [ix], ir.[rex code]as [rx], ir.[acquisition advice code]as [aa], ir.nomenclature, do.[document nbr], do.[duo qty]into duotempfrom [rsds japan]..[item record] ir inner join [rsds japan]..[due out detail] do on ir.sran=do.sran and ir.[stock number] = do.[stock number]where ir.[rex code] = '4' and substring(ir.[nomenclature],1,3) = 'use' select tmp.sran, tmp.[stock number],tmp.[o/h qty], tmp.errcd, tmp.[ix], tmp.[rx], tmp.[aa], tmp.nomenclature, tmp.[document nbr], tmp.[duo qty], ir.[stock number] as [sub nsn], ir.[serviceable balance]as [sub bal]into duotmp3from [duotemp] tmp inner join [rsds japan]..[item record] ir on tmp.sran=ir.sran and substring(tmp.[nomenclature],5,15)=ir.[stock number]where ir.[serviceable balance] > '0'select * from duotmp3drop duotempdrop duotmp3" |
|
|
|
|
|
|
|
query doesn't work in msquery