How to determine the Account Manager using sql server mgmt studio

One of the peculiarities of the Maximizer database is how the "Display Name" of a user is stored. Although you can concatenate these two fields as described above, the "Display Name" of a user is actually stored in AMGR_RESOURCES. Although not very likely, it is possible for a user to have different values in "Frist Name", "Last Name" and "Display Name", so if you concatenate the fields, you may have a situation where your assembled Display Name is different from the actual "Display Name" that you will see in Maximizer.

When I've done reports or customizations, I've always used this table and have never had any issues. For your report, you would join AMGR_CLIENT.ASSIGNED_TO to AMGR_RESOURCES.RESOURCE_ID and inclide AMGR_RESOURCES.NAME on your report research papers.

So the sql statement would be: select cl.client_id, cl.name, res.name from amgr_client_tbl cl, amgr_resources res where cl.assigned_to=res.resource_i