Some internal functions, like the one you mention, are only accessible from system stored procedures.

There is a modern way to get the database id. Give me a minute...

:laugh: You're getting worse...

It is just an alias for the result returned by APPLY. Just like T1 in SELECT *...

Jason...CTRL + SHIFT + R! :w00t:

There are sometimes multiple pages of replies. Still catches me out occasionally.

Obviously not recommended for production systems, but may get...

It isn't the problem, but I would recommend using the SQL Native Client driver instead of SQL Server.

Which SQL Server versions (e.g. 2000 and 2005) and instances (default or...

That statement makes my head spin.

I have some SSIS skillz. Send it to me if you want some abuse 😉

SELECT iTVF.*

FROM dbo.Quiz Z

CROSS

APPLY (

SELECT TOP (Z.no_to_display)

...

This is actually slightly more efficient that the TOP/MIN methods:

SELECT U.account,

least = MIN(U.value)

FROM #Sample

UNPIVOT (

...

We all have a long way to go, Wesley 😉

But thanks!

You are welcome.

I might do something like this:

USE tempdb;

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.Respondent_Search', N'U') IS NOT NULL

DROP TABLE dbo.Respondent_Search;

GO

CREATE ...

Demonstration code:

-- For demonstration purposes

USE tempdb;

GO

-- Drop tempdb objects

IF OBJECT_ID(N'tempdb.dbo.Products', N'U')

IS NOT NULL

...

CASE seems like a lot more work...? 😎