Member since ‎03-08-2012

User Statistics

  • 48 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Hello. I have an Item last purchase price . I am trying to find out where this last comes from ; looked in the following tables :AITM,ITM1,IGN1 found nothing. Any Ideas ? Thank Dov
Hello How can I use the following in query generator: /* select * from AITM T1 */ DECLARE @Date1 DATETIME DECLARE @SaleItem INT DECLARE @MinQnty Numeric (19,6) SET @Date1 = /* T1.UpdateDate*/ '[%0]' SET @SaleItem = /* T1.U_SaleIetm*/ '[%1]' SET ...
When I execute the following query I can select value for parameter '[%]' only from a list of dates that exists in the column AITM.upDatedate . How can I pass values to parameter '[%]' independent from the values in the column. for example I to s...
I have the following query that works perfectly on MSSQL ( without the parameters). But in SBO I get the following error msg: 1). [Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "t2.UpdateDate" could not be bound. ...
In AITM.UpdateDate table I have multiple records for a UpdateDate date. How can I select the last update record for that specific date?