Posted by Comagmbh on 12/19/06 11:59

Erland Sommarskog schrieb:
>
> Didn't you get a complete error message? That should tell you what is
> wrong.
>
> But I can see the error: IMSI_Blacklist.tblIMSI_Stiering_Blacklist comes
> out of nowhere. I don't know what is supposed to be, so I can't suggest
> an alternative. But I would not expect the above to work on MySQL either.
>
> Two more things:
> 1) Remove TOP 100 PERCENT and ORDER BY. They don't mean anything logically,
> but they can result in extra processing. In SQL 2000 it may seem that
> if you run a SELECT on the view that you always get data in the order
> of the ORDER BY clause, but that is mere chance, and it does not happen
> that easily in SQL 2005.
>
> 2) Try to remove the COLLATE clause. Adding to the query when it is not
> needed can prevent indexes from being used and hamper performance.
>

Hi! Okay I wrote this:

ALTER VIEW view_results_7
AS
SELECT view_results_7a.*, table.MCC,
table.MNC, ...table.HPRP
FROM view_results_7a INNER JOIN
table ON view_results_7a.MCC = table.MCC AND view_results_7a.MNC =
table.MNC
WHERE view_results_7a.IMSI <>
IMSI_Blacklist..tblIMSI_Stiering_Blacklist.IMSI


But there is still this error message:

Server: No 107, 16, state 3 procedure view_results_7
"The column prefix '%.*ls' does not match with a table name or alias
name used in the query."

[Back to original message]