Looks like adding some GOs between the inserts solves this issue. Makes sense, I'm ashamed I didn't figure this out faster.

I wrote a c# script which parses a few mysql tables, generates the according insert statements and write them to a file. Then this file is supposed to be ran...

I've tested on Sql Server 2008, one had SP2.

The queries are - simple - inserts with no temp tables, no nothing. It was generated for migrating data over.

Indeed, looks like it's not possible to do it inside a view.

I've found the solution using a dynamic PIVOT

declare @sql nvarchar(max), @Cols nvarchar(max)

;with cte as (select distinct F.FieldName from AssemblyData A

inner join Fields F on A.FieldID = F.FieldID)

select...

As I said I know how to do it with 2 selects, but I was wondering if its possible to do it with just one select. I have to inner...

SELECT MIN(Kills.KillId) AS KillId, FirstKills.BossId

FROM Kills

INNER JOIN ( SELECT MIN(Date) AS Date, BossId

FROM Kills

...

Thank you for your reply. I just wanted to make sure that theres no other way, because in the real case I also have some inner joins and a where...

Yes, thats what I did. I created a derived table and populated it with the initial data and then I've used Update on it to calculate the other fields.

Thanks for...

Worked, thank you Aaron.

Please read again my last post, I edited it.

It also gives this error:

Column 'Kills.BossId' is invalid in the select list because it is not contained in either an aggregate function...

Something like that, but not the most recent, I want the first kill and this would be the oldest. Also I want the first kill when g.Faction = 'Alliance' and...

No difference, the Union returns only 2 rows only after all.

But I think I found the problem ... "WHERE Kills.BossId = Instances.EndBossId" from the sub-selects seems to cause this. Replacing...

Hello Aaron, thanks for your fast response.

I cannot convert it to an INNER JOIN, because of the Instances.EndBossId I use inside the sub-select that would not get recognized otherwise.

I tried...