Invalid column name
hej alleJeg får: "Invalid column name 'LOCATION'", men den findes altså og jeg bruger den på samme på i andre sql-sætninger.
Nogle, som kan hjælpe?
SET DATEFORMAT DMY
SELECT E.NEWURL, COUNT(D.[Date]) AS COUNTER
FROM (SELECT ID, URL, LOWER(REPLACE(REPLACE(REPLACE(REPLACE(LEFT(Url, 7 + CHARINDEX('/', SUBSTRING(Url + '/', 8, LEN(Url) - 6)) - 1), ',', '.'), 'https://', ''), 'http://', ''), 'www.', '')) AS NEWURL
FROM KALENDER_EVENTS) E LEFT OUTER JOIN KALENDER_DATES D ON E.ID = D.EventID AND D.[Date] >= '01/8/2005' AND D.[Date] <= '01/9/2005'
WHERE EXISTS (SELECT P.URL FROM PLUSPROFIL_ANNONCE P
WHERE (P.UsedPoints < P.OrderPoints) AND P.URL LIKE '%' + E.NEWURL + '%' AND LEN(E.URL) > 5 and (E.LOCATION IN ('Internet','Radio/TV','Uden for DK','Jylland','Fyn','Sjælland')) AND (E.CATEGORY in ('Andet','Interview','Rejse','Møde','Messe','Ferie','Skole','Kursus','Foredrag')))
GROUP BY E.NEWURL
ORDER BY COUNTER DESC