Create a view from two tables having different number of Columns

所有回覆

• 2012年5月7日 上午 07:49

  解答者

   

   
  

  1

  best ask in the T-SQL forum: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

  this forum is mainly for profile and recognition system topics

  • 已提議為解答 Ed Price - MSFTMicrosoft Employee, Owner 2012年5月7日 下午 05:57
  • 已標示為解答 Ed Price - MSFTMicrosoft Employee, Owner 2012年5月7日 下午 06:27
  •  
  • 回覆
  • 引述

   
• 2012年5月7日 下午 12:44

   

   
  

  1
  If the tables are generated dynamically, perhaps you need to generate the view dynamically as well if it has to be a view. 

  ---

  For every expert, there is an equal and opposite expert. - Becker's Law
  
  
  My blog

  • 已提議為解答 Ed Price - MSFTMicrosoft Employee, Owner 2012年5月7日 下午 05:56
  •  
  • 回覆
  • 引述

   
• 2012年5月7日 下午 05:57

  擁有者

   

   
  

  0

  best ask in the T-SQL forum: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads

  this forum is mainly for profile and recognition system topics

  
  DevRogue, let us know if you want us to move it there. Also, check out Naomi's answer and mark it if it helps you solve this issue. Thanks!

  ---

  Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)

  • 回覆
  • 引述

   
• 2012年5月7日 下午 06:13

   

   
  

  0
  Sure, please move it there and also please merge to his other thread which is the same and already answered.

  ---

  For every expert, there is an equal and opposite expert. - Becker's Law
  
  
  My blog

  • 回覆
  • 引述

   
• 2012年5月7日 下午 06:13

   

   
  

  0

  I created a new thread on the tsql forum..

  and i also got an answer there..

  so please delete this thread..

  Sorry for the inconvenience. 

  • 回覆
  • 引述