[RESOLVED] Quick SQL question (MSSQL)

[MikeSnead]

I'm trying to duplicate a row in a MSSQL Database table and I'd like to do it with one query. I believe there is a way to do it in a way something like this:

insert into table_name (select top 1 * from table_name where something = true)

But I've yet to find the correct syntax if there is indeed a way so thought I might give a post 🙂

Thanks in advance!

[MikeSnead]

Argh... I was being silly... nix the parenths and it works dandy...