PostgreSQL syntax problem.

Query below will run but result is: ERROR:  out of memory for query result

SELECT
AD.ADDRESS_DETAIL_PID as ADDRESS_DETAIL_PID,
AD.STREET_LOCALITY_PID as STREET_LOCALITY_PID,
AD.LOCALITY_PID as LOCALITY_PID,
AD.BUILDING_NAME as BUILDING_NAME,

AD.LOT_NUMBER_PREFIX as LOT_NUMBER_PREFIX,
AD.LOT_NUMBER as LOT_NUMBER,
AD.LOT_NUMBER_SUFFIX as LOT_NUMBER_SUFFIX,

FTA.NAME as FLAT_TYPE,
AD.FLAT_NUMBER_PREFIX as FLAT_NUMBER_PREFIX,
AD.FLAT_NUMBER as FLAT_NUMBER,
AD.FLAT_NUMBER_SUFFIX as FLAT_NUMBER_SUFFIX,

LTA.NAME as LEVEL_TYPE,
AD.LEVEL_NUMBER_PREFIX as LEVEL_NUMBER_PREFIX,
AD.LEVEL_NUMBER as LEVEL_NUMBER,
AD.LEVEL_NUMBER_SUFFIX as LEVEL_NUMBER_SUFFIX,

AD.NUMBER_FIRST_PREFIX as NUMBER_FIRST_PREFIX,
AD.NUMBER_FIRST as NUMBER_FIRST,
AD.NUMBER_FIRST_SUFFIX as NUMBER_FIRST_SUFFIX,
AD.NUMBER_LAST_PREFIX as NUMBER_LAST_PREFIX,
AD.NUMBER_LAST as NUMBER_LAST,
AD.NUMBER_LAST_SUFFIX as NUMBER_LAST_SUFFIX,

SL.STREET_NAME as STREET_NAME,
SL.STREET_CLASS_CODE as STREET_CLASS_CODE,
SCA.NAME as STREET_CLASS_TYPE,
SL.STREET_TYPE_CODE as STREET_TYPE_CODE,
SL.STREET_SUFFIX_CODE as STREET_SUFFIX_CODE,
SSA.NAME as STREET_SUFFIX_TYPE,

L.LOCALITY_NAME as LOCALITY_NAME,

ST.STATE_ABBREVIATION as STATE_ABBREVIATION,

AD.POSTCODE as POSTCODE,

ADG.LATITUDE as LATITUDE,
ADG.LONGITUDE as LONGITUDE,
GTA.NAME as GEOCODE_TYPE,

AD.CONFIDENCE as CONFIDENCE,

AD.ALIAS_PRINCIPAL as ALIAS_PRINCIPAL,
AD.PRIMARY_SECONDARY as …

Query problem in postgreSQL

There are 33 tables and there is a query that is meant to set the delimiter as '|'

COPY address_alias_type_aut
C:\GNAF\Authority Code\Authority_Code_ADDRESS_ALIAS_TYPE_AUT_psv.csv' DELIMITER '|' CSV HEADER;
 
But it will not run:
ERROR:  syntax error at or near "C"
LINE 3: C:\GNAF\Authority Code\Authority_Code_ADDRESS_ALIAS_TYPE_AUT...
        ^
SQL state: 42601
Character: 30

I've doublechecked the folders and file names in C: drive and they appear to be correct (files uploaded here)
The full tables setup query and the full delimiter query are attached.

Help will be much appreciated.
create-tables.txt set-delimiter.txt Authority-Code.rar

Need help with changing Microsoft Access SQL query to show date entered records that are more than 7 days old.
So far a lot of suggestions have not really worked for me at this link so I decided to add this as a new question:

https://www.experts-exchange.com/questions/29140112/Need-help-with-creating-a-cross-tab-report-that-would-identify-the-last-date-an-employee-entered-time.html?headerLink=workspace_answered_questions

I know must include : HAVING but no data is coming up with records that do have dates more than 7 days old.

SELECT Employees.EmployeeID, Employees.UserName, Max(TimeSheetData.DateEntered) AS MaxOfDateEntered
FROM Employees LEFT JOIN TimeSheetData ON Employees.EmployeeID = TimeSheetData.EmployeeID
GROUP BY Employees.EmployeeID, Employees.UserName
HAVING DateValue(Max(TimeSheetData.DateEntered)) > DateAdd("d",7,Date())
ORDER BY Max(TimeSheetData.DateEntered) DESC;

Select all Open in new window

When I try the above I get DataType mismatch in criteria expression.

If I try below- I get no errors but I also get no records which can't be right cause 80% are over 7 days old

SELECT Employees.EmployeeID, Employees.UserName, Max(TimeSheetData.DateEntered) AS MaxOfDateEntered
FROM Employees LEFT JOIN TimeSheetData ON Employees.EmployeeID = TimeSheetData.EmployeeID
GROUP BY Employees.EmployeeID, Employees.UserName
HAVING Max(TimeSheetData.DateEntered)>DateAdd("d",7,Now())
ORDER BY Max(TimeSheetData.DateEntered) DESC;

Select all Open in new window

change ON in LEFT OUTER JOIN based on another fields value

SELECT [contract_number]
      ,[Comp_Code]
      ,[Debitor]
      ,[Company]
      ,[BusinessPartnerCode]
       ,[Track_Name]
      ,[Cust_ZZNA_SCD]
      ,[SubTrack_Name]
      ,[DSO]
      ,[Track_Name]
      ,etdso.dso_180
      ,etdso.dso_270
      ,etdso.dso_360
      ,etdso.dso_450
  FROM [program_flow].[dbo].[EXTNO_DSO] etno
  left outer join
  [program_flow].[dbo].[EXTENDED_VIEW_DSO] etdso
ON
  etno.BusinessPartnerCode = etdso.Cust_ZZNA_CD
  
  where [Track_Name] is not null

Select all Open in new window

I need to change the "ON" condition based a a fields value if possible

If the [BusinessPartnerCode]   "isNumeric"  no  alpha characters     I.E.(081111111, 354276567  ETC..)
THEN

ON
  etno.BusinessPartnerCode = etdso.[Debitor]

OR

If the [BusinessPartnerCode]  ends with  "AA"   i.e.  (GFDAA, TGRAA, JHGAA  ETC...)
THEN
ON
etno.BusinessPartnerCode = etdso.Cust_ZZNA_CD

OR
ELSE
ON
etno.BusinessPartnerCode = etdso.Cust_ZZNA_SCD

----------------------------------------
Thanks
fordraiders

SELECT        COUNT(Receipt_Detail.Receipt_Number) AS totalcountreceipt, SUM(Receipt_Detail.Amount_Applied) AS receiptamount, Invoice_Header.Invoice_Number,?
FROM            Invoice_Detail INNER JOIN
                         Invoice_Header ON Invoice_Detail.Invoice_Number = Invoice_Header.Invoice_Number INNER JOIN
                         Member_Association ON Invoice_Header.Member_Number = Member_Association.Member_Number INNER JOIN
                         Member ON Invoice_Header.Member_Number = Member.Member_Number INNER JOIN
                         Receipt_Detail ON Invoice_Detail.Invoice_Number = Receipt_Detail.Invoice_Number INNER JOIN
                         Receipt_Header ON Member_Association.Member_Number = Receipt_Header.Member_Number AND Receipt_Detail.Receipt_Number = Receipt_Header.Receipt_Number
WHERE        (Invoice_Detail.Charge_Code = 'D' OR
                         Invoice_Detail.Charge_Code = 'T' OR
                         Invoice_Detail.Charge_Code = 'N')  (Invoice_Header.Invoice_Date BETWEEN '20181201' AND '20190131') AND (Receipt_Header.Deposit_Date BETWEEN 
                         '20181201' AND '20190131')  and (Invoice_Header.Invoice_Amount > 0)
GROUP BY Invoice_Header.Invoice_Number
ORDER BY totalcountreceipt DESC

Select all Open in new window

Inside of "?" if I want to add like below, is it possible? Please show me how.

select top 1 (Receipt_Detail.Amount_Applied) where Receipt_Header.Deposit_Date BETWEEN '20181201' AND '20190131' order by Receipt_Header.Deposit_Date asc

I have two main tables where an employee (Employees) saves the date and hours spent on a task in a table called TimeSheetData.
The query I want is basically give me the last date each employee has saved time which would pull from the fieldname:  DateEntered.

It would look like:

Employee               DateTimeWasSubmitted

EmployeeA              3/21/2019
EmployeeB              2/1/2019
EmployeeC      
EmployeeD              1/14/2019

I provided a Microsoft Access sample - note how some employees maybe blank cause the DateEntered did not get out.  
How would I get this accomplished?  I want it to list all employees whether time was entered or not.
ee-question-last-date-emp-entered-.accdb

Hi All,
The following is an Extract from a table.
The table itself has multiple different Server_Name values

I run the following against the table

select
 Server_Name,
 Audit_Action_Name,
Audited_Result,
'' as Result from SQL_Server_Audit

Select all Open in new window

The Result column needs to have a ‘Pass’ value when and only when a specific Server_Name  has the three entries shown for ‘Audit_Action_Name’ and ‘Audited_Result'
Any guidance appreciated.
I am currently looking at the Table Ranking Function

Hello,

I am trying to figure out a SQL query that can do the calculations I am expecting to calculate the internet browse window time for a user within a time period. From the start time (Column B in the spreadsheet), we need to add 60 seconds and check the next following session's start times and see if it falls within that 1 minute's time frame or not. If it does then it is 1. Repeat the same logic for the next browse window and check if it falls within the next minute, then it is 2.

I hope it makes sense if you look into the logic document that I have attached.

The SQL table will have "Start Time" and "Session ID" and the expected outcome will be in "Browse Window Time".

I am attaching a sample logic and the expected result in the spreadsheet (Column A is the expected outcome) to get the value of the browse time. Can someone please help?

Thank you
Logic.docx
Exchange-Experts-sample.xlsx

Hi  I have  a table  TB-Docs in Sql Server 2016  with a filed Name ( and other fields)  . There are some names ending  like Doc1VOL01 , Doc1VOL11  , Doc1Vol123

Eg.
    Doc1Vol01
    Doc1Vol11    
    Doc3Vol123
 
   I need result with Volume rows and the substring of the  Document name  ( All I need to know is how to get the substring like Doc1 from a string of Doc1Vol01)
        Name                 Doc
        -----                     ----
     Doc1Vol01           Doc1
    Doc1Vol11            Doc1
    Doc3Vol123          Doc3


Edit : Name can be of any length , for example, there can be a Doooooc1Vol01

Hi, my below SELECT is in a stored proc and when I execute it its taking 9 seconds . Is there anyway to fine tune the query to bring the time down and improve the performance ?
Thanks


SELECT
      LatestStatuses.SiteKey,
      LatestStatuses.component,
      LatestStatuses.[Status],
      LatestStatuses.StatusDetail,
      LatestStatuses.[Timestamp]
 FROM (
      SELECT    
            SiteKey,
            Component,
            Timestamp as [Timestamp],
            RANK () OVER (PARTITION BY sitekey, component ORDER BY Timestamp DESC) AS StatusResult
            ,status as [Status]
            ,StatusDetail
      FROM StatusLog) AS LatestStatuses
WHERE StatusResult = 1
ORDER BY SiteKey, Component