Pages

Banner 468 x 60px

 

Monday, March 27, 2017

Concate SQL

0 comments
SELECT        CONVERT(varchar(50), Id) + ' ' + CONVERT(varchar(50), ProductionID) AS ConcatnatedColumn
FROM            Production.CPOProduction


=========================OR==================


SELECT        'Ipl' + CONVERT(varchar(50), Id) + '' + CONVERT(varchar(50), ProductionID) AS ConcatnatedColumn, Id, ProductionID, EstateID, ActiveMonthYearID, CropYieldID, CPOProductionDate, QtyToday, QtyMonthToDate,
                         QtyYearToDate, CreatedOn, CreatedBy, ModifiedBy, ModifiedOn, CPODate, TankID, DataAreaId
FROM            Production.CPOProduction

0 comments:

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH