What would be the proper syntax for this? I want to use openquery to open another query if the value is null. Is it possible to do that? I'm using SQL server 2005
EXAMPLE:
CASE WHEN (COLUMNNAME)ISNULL THEN Openquery(Servername 'Select TOP 1 from dbo.db.column inner join on columname) else 'DEFAULT JOB FUNCTION' END
EXAMPLE:
CASE WHEN (COLUMNNAME)ISNULL THEN Openquery(Servername 'Select TOP 1 from dbo.db.column inner join on columname) else 'DEFAULT JOB FUNCTION' END