I also get error

Msg 195, Level 15, State 10, Line 2

'VARCHAR' is not a recognized built-in function name.

Thanks SSC. Now I've learnt something new! Cheers:-D

SS Committed

SELECT compatibility_level

FROM sys.databases

WHERE database_id=DB_ID();

Your code resulted in compatibility_level 100! :unsure:

SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members

Last Login: Today @ 2:04:58 PM

Points: 1,712, Visits: 4,801

Thanks

It appears I have SQL Server 12.0.2000 (top of the instance). ...

I tried on SQL 2014 but still got the 🙁

Which version does this code work on?

I was using SQL Server 2014 instance

Microsoft SQL Server Management Studio12.0.2000.8

I got error message too so I failed the question.

Msg 195, Level 15, State 10, Line 3

'VARCHAR' is not a recognized built-in function name.

Wish I was at th PASS Summit - Always wanted to visit Seattle! :-:alien:

Strange - I got 5 rows returned. Rows id 1,2,3,4,5 am I losing my lid? GM the Old Hand

The result I get when I ran all the code is 48893

DECLARE @sql NVARCHAR(MAX)= '';

WITH Tally ( n )

AS (

-- 1000 rows of tally table

...

OK Thanks. Since I'm new to the forum's I appreciate the feedback.

Sorry but I think the question was misleading/unclear. All were valid Object Reference Format of object names.

server.database.schema.object

Four-part name.

server.database..object

Schema name is omitted.

server..schema.object

Database...

Sorry Stewart - it's you to thank. g