Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

LOOKUP and IIF Expand / Collapse
Posted Wednesday, February 26, 2014 11:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 20, 2015 1:14 PM
Points: 364, Visits: 1,079
I am trying to count all decvices which are greater than 1 and count those as "1" else blank.But I am also doing a lookup at the same time.


But I get an Error#. Let me know whats wrong with syntax.
Post #1545707
Posted Thursday, February 27, 2014 12:24 AM



Group: General Forum Members
Last Login: Today @ 2:23 AM
Points: 14,840, Visits: 12,893
What is the error?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1545732
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse