INSERT INTO CollOrder(CollOrder,CollBy,RccID)
select distinct 'RecipeStatCollection.sHeadline','ASC',RccID
FROM RecipeStatCollection
Frågan#1
Hej igen!
Skulle vilja uppdatera fält i en tabell med alla id(RccID) som finns i en annan tabell mha QueryAnalyzern
INSERT INTO CollOrder(CollOrder,CollBy,RccID) Values('RecipeStatCollection.sHeadline','ASC',(SELECT DISTINCT(RccID) FROM RecipeStatCollection))
Denna fungerar inte, får felmeddelandet:
Server: Msg 1046, Level 15, State 1, Line 4
Subqueries are not allowed in this context. Only scalar expressions are allowed.