Thnaks Chirag.

Grt Answer

Shall we use DML (INSERT, UPDATE, DELETE) inside a function?

Shall we use DDL inside a function?

But Chirag,

You cant call a function from a SELECT statement and send a column name as a parameter.

Shall we sens a column name as a parameter in SP?

Hi Jim and Adi,

Thanks as i have understood what you want to say.

arup_kc (8/25/2009)

SELECT a,b FROM #temp GROUP BY a,b ORDER BY a,b

Suppose I have 100 columns in my table and I need to GROUP BY those columns by 50 columns.Is there...

Thanks Martin.

But is it possible to provide column names in SELECT clause which are not in GROUP BY clause?

Unfortunately, in this case, you only substitted one form of RBAR for another form of RBAR. The best solution in this case is to find a set-based solution to...

Hi everybody,

Thanks for constant support. At least I have got a lot of tips fromt he forum discussions.

The first thing I should say, I had some misconceptions which are...

Hi Anton, u r right...sorry 4 the typo error

Hi,

Sorry for late replying, actually I was out of net for last 3 weeks. I have seen the comments. I do agree that I had some misconceptions, which are now...

Hi,

I am really perplexed...can anybody tell me what is the relation of this with SQL? (Though I guessed right and awarded 2 points 😀

For my case, I ll vote t char(1), as I am not dealing with any UNICODE data. Hence, space is more important to me rather tha flexibility.

Thanks jack,

I am also thinking to do the same, but your vivid code will help to do the thing faster.

Thanks a lot.

Hi,

My problem is solved.

We had one dataset option from the expression field. I have used that instead of using custom function and IT IS WORKING 😀 🙂

Hi Tom,

I have tested with Business Intelligence studio 2005 which comes along with SQL Server 2005...still that option is not coming.

Probably that comes with only VS 2005.

Anyway, thanks a ton...