Query

Question

Query

Reddy-360666

SSC Veteran

Points: 286
More actions
October 20, 2006 at 9:31 am

#367663

SET @per=(select top 1 substring(Col001,194,2)from Empwhere substring(Col001,1,6) = 'HEAD')
If Exists(select substring(Col001,1,2)from Emp where substring(Col001,17,2)='DH'not in (@per))
Begin
RAISERROR ('Mesg')
return
end

I am getting the error at not.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Your missing something

If Exists(select substring(Col001,1,2)from Emp where substring(Col001,17,2)='DH' And substring(Col001,17,2)='DH' not in (@per))

But is easier to read if

If Exists(select * from Emp where substring(Col001,17,2)='DH' And substring(Col001,17,2)='DH' <> @per)

Reddy-360666 SSC Veteran Points: 286 More actions · Answer 2

Reddy-360666

SSC Veteran

Points: 286

October 20, 2006 at 9:43 am

#667115

still am getting the same error.

Reddy-360666 SSC Veteran Points: 286 More actions · Answer 3

I doubt if I can have multiple where clause in a single select statement

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 4

Tell me what u wanted to do. There is syntax error.

substring(Col001,17,2)='DH'not in (@per) is incorrect. what are u trying to do.

Thanks

Sreejith

Reddy-360666 SSC Veteran Points: 286 More actions · Answer 5

I want to check

1) select substring(Col001,1,2)from Emp where substring(Col001,17,2)='HE'

2) select substring(Col001,1,2)from Emp where substring(Col001,17,2)='DH' not in (select substring(Col001,1,2)from Emp where substring(Col001,17,2)='HE')

all the records in 2 shud match with 1 other wise kick an error.

Ray M SSC-Insane Points: 21093 More actions · Answer 6

What?

Of course you can have multiple items in the where clause, Unfortunatelly I wasn't paying attention when I posted

Try this.

If Exists(select substring(Col001,1,2)from Emp where substring(Col001,17,2)='DH' And substring(Col001,17,2) not in (@per))

Reddy-360666 SSC Veteran Points: 286 More actions · Answer 7

syntax is working but unable to filter the records from not in

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 8

I want ur question in Plain English (No Not IN...)

what column are u checking in NOT IN Clause?

Ray M SSC-Insane Points: 21093 More actions · Answer 9

Fine,

Can you post a table definition, some sample data, and what you want as an expected result.

Thx

Reddy-360666 SSC Veteran Points: 286 More actions · Answer 10

I am checking @per in my NOT IN caluse, uou can check my 1st posted mesg.