sql server - SQL returning 'Subquery returned more than 1 value' error -

-

okay bit of code thats giving me error:

select orderid, requireddate,     (   select datediff(dd,requireddate,shippeddate)         sales.orders          shippeddate > requireddate     ) 'dayslate' sales.orders

and "subquery returned more 1 value. not permitted when subquery follows =, !=, <, <= , >, >= or when subquery used expression." error.

i'm not quite sure how fix it, when click on error message highlights select orderid, requireddate bit.

is there wrong i'm not catching?

try below sql

select      orderid, requireddate     , case          when shippeddate > requireddate datediff(dd,requireddate,shippeddate)         else             0       end 'dayslate' sales.orders

the case..when statement can replace subquery


Comments

Post a Comment

Popular posts from this blog

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

parcelable - Unmarshalling unknown type code exception while reading parcel values in Android 4.4+ -

-
i'm using parcelable interface , working fine till android 4.3 (jelly bean) when install same app on device running under android 4.4+ (kitkat) crashing while reading parcel. throwing below error : java.lang.runtimeexception: parcel android.os.parcel@42acce90: unmarshalling unknown type code 6881383 @ offset 1864 when try read : getintent().getextras().getstring("type").contains("some_type"); i have put extra in intent : intent ointent = new intent(getactivity().getapplicationcontext(), eventfragment.class); ointent.putextra("type", "some_type"); after long time , r&d, came know should not use arraylist inside arraylist , within parcelable object. causing issue. so end-up using serializable interface provided java , both concept same.
Read more