http://msdn.microsoft.com/en-us/library/ms160893(SQL.90).aspx

(UTF8 String User-Defined Type)

And an alternative:

SELECT CA.*

FROM dbo.FilteredIncident FI

CROSS

APPLY (

SELECT TOP (1)

...

You could write a CLR procedure to work around this restriction.

Or, if the server happens to be already running MSDTC, you could use a loopback linked server.

INSERT...EXECUTE (4-part name) works...

Myth.

http://en.wikipedia.org/wiki/Physical_Address_Extension

Busted.

😛

You should post this new question in a thread of your own.

That said, the answer is simple enough. See Join Fundamentals in Books Online. The key part is:

Inner...

:laugh: :laugh: :laugh:

ALVIN!!!!

No worries 🙂

Not really a correction, more of a slight expansion of your point. You're very welcome in any case 🙂

I very...

I'm afraid your point is lost on me. Would you elucidate?

Yes, for data modification only. See http://msdn.microsoft.com/en-us/library/ms187043.aspx, the important part is reproduced below:

Using SET ROWCOUNT will not...

Way too much detail Barry :sick: 😀

Running a profiler trace for the SQL issued by SSMS (2008, 10.0.2757) gives the following batch (very slight changes made to translate the original sp_executesql-type syntax):

DECLARE @Param0 NVARCHAR(4000);

DECLARE @Param1 NVARCHAR(4000);

DECLARE...

No - I didn't mean to suggest that the article is terrible (certainly not on the scale of 'suspect db') - just that it's frustrating being connected through what appears...

The 'sigh' is a link to today's featured article. I'm away from home an unable to reply as I would...