Hey all...i have a problem with a query like this...:declare @table1 nvarchar(max);declare @table2 nvarchar(max);declare @table3 nvarchar(max);declare @table4 nvarchar(max);declare @table5 nvarchar(max);declare @table6 nvarchar(max);Set @table1 = (SELECT dtPartition.partitionid FROM dtPartition WHERE dtPartition.status like ('0'))Set @table2 = (SELECT dtPartition.partitionid FROM dtPartition WHERE dtPartition.status like ('0'))Set @table3 = N'dbo.dtEvent_'Set @table4 = N'dbo.dtPrincipal_'Set @table5 = @table3 + @table1Set @table6 = @table4 + @table2SELECT dtEvent.EventNo as "Event ID:", dtEvent.creationtime as "Erstellt am:", dtPrincipal.struser AS "User Account:", dtMachine.description AS "Computer:" FROM @table5 AS dtEvent, dtMachine, @table6 AS dtPrincipalWHERE dtMachine.id = dtEvent.eventmachineid AND dtPrincipal.id = dtEvent.primaryuserid AND dtEvent.eventno IN ('528')
Theire is an error....but i don't know what i can do...Thanks.