Update statement with join

 UPDATE scrcrd SET
scrcrd.sku_health = skrev.sku_health

FROM tbl_SLM_Scorecard scrcrd

JOIN tbl_SLM_SKU_Review skrev

ON scrcrd.material = skrev.material and scrcrd.month_yr = skrev.month_yr

where scrcrd.month_yr = '2015-01-31' and skrev.material is not null

and skrev.sku_health <> scrcrd.sku_health

Comments

Post a Comment

Popular posts from this blog

Hey Ram song Akashe Jyotsna meaning

This is one of the songs I always wanted to know meaning. Got this translated by a friend out of curiosity. Bengali version : Akashe jyotsna Phuler pathe chita baagher gayer karam Hridoy amar horin jano Ratrer ei niraboder bhetor, kondike cholechi? Rupali paatar chaya amar shorire Kothao kono horin neyi Aar joto door jaayee, kaashter moton banka chaand Shesh shonale horin, shorsho khete niyeche jano Taar par dhire dhire dube jaache Shata shata mrigedaar choker ghumer andhokaarer bhetor English : Moonlit sky On the Forest Trail the Scent of the Leopard My heart is like deer In the silence of this night, which way am I going ? The silvery shadow of leaves on my body No more deer anywhere As far as I go I see the moon bent like a sickle Cutting the last golden deer-grain Then sinking slowly Into the darkness of all the sleep In the eyes of a 100 does.
Read more

DNX on ubuntu 14.04 throws Missing method exception

Error Missing method System.Runtime.InteropServices.Marshal::GetTypeFromCLSID(Guid) in assembly /usr/lib/mono/4.5/mscorlib.dll, referenced in assembly /home/netdevlinux102/.dnx/runtimes/dnx-mono.1.0.0-rc1-update1/bin/Microsoft.Dnx.Compilation.CSharp.dll System.MissingMethodException: Method not found: 'System.Runtime.InteropServices.Marshal.GetTypeFromCLSID'.   at System.Lazy`1[System.Boolean].InitValue () [0x00000] in :0 --- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x00000] in :0   at Microsoft.Dnx.Runtime.Common.EntryPointExecutor.Execute (System.Reflection.Assembly assembly, System.String[] args, IServiceProvider serviceProvider) [0x00000] in :0   at Microsoft.Dnx.Host.Bootstrapper.RunAsync (System.Collections.Generic.List`1 args, IRuntimeEnvironment env, System.String appBase, System.Runtime.Versioning.FrameworkName targetFramework) [0x00000] in :0 ...
Read more