That does indeed work;

CREATE SYNONUM synName

FOR

[linkedServerName].[databaseName].[dbo].[tableName]

Thanks!

Thanks for this! They gave me the platform to, I think, solve the problem;

WITH cte_Clockings AS

(

SELECTE.EMP_Forename, E.EMP_Surname,

ISNULL(CASE C.CLK_Type

WHEN 'I' THEN 'In'

WHEN 'B' THEN 'Out (Break)'

WHEN 'R' THEN...

Thanks

The CTE trick doesn't seem to work either. Well the solution does work, but it's not doing what I want to achieve.

John Mitchell-245523 (6/2/2011)

---

As for only returning the most recent activity for each employee, do something like this:

SELECT

Employee

, MAX(ActivityTime) AS ActivityTime

FROM

MyTable

GROUP...

That's the 'problem', I connect to one database in my connection string, then reference tables, columns...

They are the same physical server, so yes the server can ping itself by name and resolve to IP address. As above, the 2 instances are on the same physical...

OK, my problem is solved; it was a double hop issue between the various devices. Chaning the SQL service account to use Kerberos fixed it.

Another problem; is it possible to...

Sorry to dig up this old thread, but i've come across this problem.

The route pcs take is:

Client PC -> Web Server (IIS 6.0) -> SQL Server 2005 -> Domain Controllers

I...