Please, important: group by

[luigiida]

Hi I'm trying to compile the following stored procedure but I receive an error message regarding the "group by":
--******************************
use test
GO
create proc proceduretest
@vertice1 [nvarchar](255)

AS
select @vertice1 as first, RefID as RefID
into firstTab
from start
group by @vetice1, RefID

GO
--*******************************
where is the error??
Thanks,
Luigi

 

[Sabnac]

Group by @Vertice1 not @vetice1
But put the error message it will be easier to help you

 

[swampBoogie]

Does @vertice1 contain a column name?

In that case you must use dynamic SQL

create proc proceduretest
@vertice1 nvarchar(255)

AS
exec('select ' + @vertice1 + ' as first, RefID as RefID
into firstTab
from start
group by ' + @vetice1 + ' , RefID ')

Your query does not make much sense otherwise.