>Hi All,
>
>First, let me get this off my chest. "I Hate SQL Server Help! I Hate SQL Server Help! I Hate SQL Server Help!"
>
>okay, now I have a select statement:
>
>SELECT DISTINCT RunRoute.RunRte_Rte_ID "
>FROM RunRoute "
>WHERE '20' = RunRoute.RunRte_Run_AutoID AND
>RunRoute.RunRte_Rte_ID != 'NULL' AND RunRoute.RunRte_Rte_ID != ''
>
>
IS NOT NULL instead of !='NULL'
And RunRoute.RunRte_Run_AutoID = '20'
Also you should specify database name.
FROM dbo.RunRoute
>I did several LARGE Select statements into temporary tables before this in the same query window, and they worked fine. This is to permanent tables and it errors on me. Help is not helping me on this.
>
>What do these errors mean, how can I check things for it?
>
>TIA
>Beth
If it's not broken, fix it until it is.
My Blog