السلام عليكم ورحمة الله وبركاته
I have two views as follows
view PartsRec that has the following columns and values:
recPartNo. - recDate - recQty - recStck - recSupplier. with values( 01 - 7/7/2013 - 5 - 25 - supplier1) and the second view has the columns and values : movPartNo. - movDate - movQty - movStck - movMchNo. with values (01 - 8/8/2013 - 10 - 15 - mch1) . i want to create a new view from the two views and has the following columns
PartNo - Date - recQty - movQty - Stck - recSupplier - movMchNo. with two rows ( 01 - 7/7/2013 - 5 - null - 25 - supplier1 - null) the second row values( 01 - 8/8/2013 - null - 10 - 15 - null - mch1) . note that the combined columns have the same data type. how to do this in sql server 2008r2
كيف يمكن تحقيق ذلك باستخدام جمل اس كيو ال او باستخدام المعالج او كليهما وجزاكم الله خيرا كثيرا
