gchg
Explorer
Member since ‎2024 Nov 03

User Statistics

  • 18 Posts
  • 0 Solutions
  • 5 Kudos given
  • 1 Kudos received

User Activity

Is there a way to SELECT all the columns in a Table except those with computed values?
HiIf I run - Describe TableName - in Interactive SQL it returns the column name, type, nullable and Primary Key - but when running the same from a .NET app it throws the above error. The full text of the error is below. Any ideas?ThanksSap.Data.SQLAn...
This produces several rowsBEGIN DECLARE DocumentDate Date; SET DocumentDate = '2025-01-01'; SELECT IsNull(Position, 0) AS 'Position', IsNull(Nom_Code, 0) as 'NomCode', IsNull(Nom_Name, 'NA')as 'NomName', (SELECT IsNull(SUM(Credit), 0) - IsNull(SU...
This query...BEGIN DECLARE DocumentDate Date; DECLARE AssessmentsNormal INTEGER; SET DocumentDate = '2025-01-01'; SET AssessmentsNormal = (SELECT Dues_Nominal FROM Annual); SELECT IsNull(Position, 0) AS 'Position', IsNull(Nom_Code, 0) as 'NomCode',...
If I use this statementSELECT SUM(Debit) - SUM(Credit) FROM A_Purchase_Ledger WHERE Supplier_ID = 16It returns 0 as the sum of debit is 250 and the sum of credit is 250. However, in this...SELECT A_Purchase_Ledger.Supplier_ID AS 'SupplierID', A_Purc...
Kudos from
Kudos given to