By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Subquery returned more than 1 value. This is not permitted when the subquery follows

P: 3
hi, i execute a store procedure got
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.' message

is there any one help with these codes below
.......
SET @strSQL = (@strSQL + ' AND p.PropertyID NOT IN ( ' + (SELECT DISTINCT a.propertyID
FROM propertyAvailability a
WHERE a.date >= CONVERT(varchar(10), getDate(), 103)
AND a.date <= CONVERT(varchar(10), getDate(), 103) )+')')
..........
May 14 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.