if exists(
select p.idpipe,
       DocNum = case when p.[end] = 'BE' 
           then ps.idDocumentNumber 
	 when @end = 'DE' 
	   then ps.idDocumentNumberDE 
	 else null
	 end
from #p p
join station ps on ps.idstation = p.idpipe
where DocNum <> @IdDocument )

quote:

---

Originally posted by FUNCTOR

Hi,

I've got a weird scenario. I have one table, "Station" that has many columns, two of which contain the the same type of information but are not the same values (IdDocumentNumber and IdDocumentNumberDE). I tossed in a case statement to pull the information from a one field or the other depending on a value in a temporary table "p". The column in the temporary table is called "end". I also have a variable called @IdDocument of type int. I get an error on the where clause when i use the alias column names. Invalid column name 'DocNum'. I know it doesn't like the column alias, but don't know how to proceed.

Any help would be appreciated!

Thanks!

Can you please provide the list of columns of both the tables .


First insert the all the records into temp table 

select p.idpipe,
        case when p.[end] = 'BE' 
           then ps.idDocumentNumber 
	 when @end = 'DE' 
	   then ps.idDocumentNumberDE 
	 else null
	 end As DocNum into #temp 
from #p p
join station ps on ps.idstation = p.idpipe

Now after doing that you can check the existence of records in 

temp table 

if exists( select 1 from temp where DocNum <> @IdDocument )

Try doing this 

---