Most valuable professional
  • Hot Topics

Excel Excel query a view from SQL

Dear Expert i have 6 table in SQL Server and i have created one View ("View_1") and in that i have one column name ("PayerCustomer") i want value in this column which merge two column like Column name "Payer" and second column "Customer" e.g in Payer column have Value "Atul" and in Customer Column have value "Jadhav" then i want to merge this two value and want result in "PayerCustomer" like "AtulJadhav" and if Second Column is blank then it give me value like "AtulAtul" so i have tied below code but it is not wokring CREATE TRIGGER Trg_View_1 ON View_1 FOR INSERT, UPDATE AS UPDATE View_1 SET payerCustomer = payer + ISNULL (Customer, Payer) GO

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 29, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel