also, can you clarify if tag+type is unique or is just tag unique?

so, can you repost the creation script with all the columns?

Ok, couple of things...

Your table creation script does not contain a column called "type"??

Do you have any indexes/constraints on the table?

In the code fragment

t.r.value('.[1]','varchar(512)')

".[1]" retrieves the first node in t.r

and

value('.[1]','varchar(512)')

converts that node's value to a varchar(512).

John, please post the table creation script.

Here is a quick example (using WayneS sample code)

declare @test-2 TABLE (RowID int IDENTITY, Data varchar(200))

insert into @test-2

select 'some regular text' UNION ALL

select 'email: <bob.jones@domain.com>' UNION...

Hi, you asked about doing this with joins...

select Day, PV=sum(flex)

,Looker=sum(CASE WHEN TINB.ip...

noeld (4/28/2010)

Not sure why would you even use APPLY on that case instead of :

SELECT g.GroupName , COUNT( a.id ) AS id_count

FROM newsdata.dbo.Groups AS g

...

In terms of performance on queries like your example, I agree there should be very little difference, although as Jeff said, that may not be true for very large datasets.

However,...

yes, if you have the correct license and media, you can run an "edition upgrade" from the installer

While I certainly agree that I personally could use less meetings, you must not forget the importance of them to those people who would otherwise be forgotten/ignored if the "company"...

if you take this simple example

Table1 ( a int, b int)

Table2 ( c int )

select t.a,t.b

from Table1 as t

where t.a not in (select a from Table2)

To the optimiser, this is...

Because when it is a subquery the column is a valid column of the main table/cte.

Classic.

SQL "knows" about the field because it is in the base table cte_TestRecs that you are querying.

If you properly qualify the names of the columns in your select, then you...

You know what, checking back (because it was niggling away...