use result of sql select in if else

Question

I am trying to construct a query where I check the number of rows returned from a sql select. For example, I want to check that if the number of rows returned from a query are greater than 3, then do something else do nothing

if @@rowcount(select clientId from Clients group by clientId) > 3
   PRINT 'WARNING'

Any ideas appreciated

Are you trying to do it all inside a query or are you using t-sql ? — AJC
– AJC, Commented Aug 19, 2011 at 16:45
Well, in a Stored Procedure you can use T-SQL. As in select [at]count = count(*) from table where condition and then use the value of [at]count anywhere in your SP. If within a query, you have to do something like I said in my answer. You can put the case in the select or the where — AJC
– AJC, Commented Aug 19, 2011 at 18:22

AJC · Accepted Answer · 2011-08-19 16:43:42Z

4

Try:

case
    when (select count(*) from table where condition) > 3 Then
    else
end

Hope this helps...

answered Aug 19, 2011 at 16:43

AJC

1,8931 gold badge17 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aaron Bertrand · Accepted Answer · 2011-08-19 16:46:32Z

3

DECLARE @Count INT = (SELECT COUNT(DISTINCT ClientId) FROM Clients);

IF @Count > 3
    PRINT 'WARNING';

answered Aug 19, 2011 at 16:46

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Comments

teenboy · Accepted Answer · 2011-08-19 16:56:02Z

1

Hope this helps

[EDITED]

DECLARE @Cnt AS INT
select @Cnt = COUNT(clientId) from Clients group by clientId
if @Cnt > 3
PRINT 'WARNING'

edited Aug 19, 2011 at 16:56

answered Aug 19, 2011 at 16:47

teenboy

3682 silver badges13 bronze badges

2 Comments

Aaron Bertrand Over a year ago

This returns the data, whether there is 1 client or 100,000 clients. Not sure that is desired.

teenboy Over a year ago

I changed from @@ROWCOUNT TO variable. Both my logic should work. This will show WARNING, if the client count is greater than 3 only.

Collectives™ on Stack Overflow

use result of sql select in if else

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related