Hi,

Functions are best suited for my requirement. I use the value returned by a scalar user defined function as a part of

insert into t1 select *, function_f1() from t2.

i...

Thanks to all of you for your help. I found the problem in my query.

It was expecting a column name in the group by clause. Since I had hardcoded...

GilaMonster (12/20/2007)

---

Why is the group by there at all? You aren't doing any form of aggregation that could require a group by.

If you're trying to eliminate duplicate rows, rather use...