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: Yesterday @ 3:47 PM
Points: 356, Visits: 1,059
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: Yesterday @ 6:14 AM
Points: 14,739, Visits: 12,833
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