Pages

Banner 468 x 60px

 

Thursday, November 16, 2017

Dateadd in SQL

0 comments
Dateadd in SQL :

SELECT Dateadd(hour, -7, [DateProcess]) AS [DateProcess]
      , [Id] AS Recid
      ,[Linenum] as Linenumber
      ,[ItemNumber]
      ,[Quantity]
      ,[Warehouse]
      ,[WBNumber]
      ,[Storage]
      ,[UOM]
      ,[ModulIplant]
      ,[DataAreaID]
  FROM [DB_Staging].[Distribution].[WBDRubberDetails]

OR

CONVERT(VARCHAR(10), [DateProcess], 111) AS DateProcess

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