Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LOOKUP Expand / Collapse
Author
Message
Posted Tuesday, February 25, 2014 3:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 11:44 AM
Points: 401, Visits: 1,199
My source table is Work
Destination table is Device
I want to get all the devices where Monitor = "New" and get a count of all of them to be displayed.
How can I do it through lookup expression
. I tried the one below , but doesn't look correct...
Any Advises.
=
LOOKUP(Field!DeviceName,Field!Device_Name,Field!Monitor="New","Device")
Post #1545151
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse