... and you can open fire on the server run with a shotgun and call your service rep for a free replace of the servers too.

I wouldn't try...

I still don't see anything in the matrix options to add a new DATA column (not another grouping).

Again here's what I see in case I'm just missing something obvious :...

Exactly... that's because the servers needs to assume that the state of the DB and data will not change by calling the function (again, by design because the server would...

That's the thing Gift... it's not even a database change. My customers wants to add a column in the middle of the report which basically shows (SUM(Cola) + SUM(ColB)...

are you qualifying the proc name when calling it?

I'm using VS 2005. I'm right-clicking all over the place (from the bottom to the top) and I'm never given the option to add the column where I want...

Can't be done... and shouldn't be done (by design).

What exactly do you want to do?

Yup, that solution solved my problem, thanx for the help.

Now I have more respect for ms access... that iif works in there ;).

I can add to that list quite easilywhich will put you on the right tracks...

once the query sees it can use the index, it will choose a seek if the...

Correct me if I'm wrong (I never worked with the text datatype), but I think this is what Jeff means :

SELECT id, CONVERT(NVARCHAR(MAX), ColName) AS ColName INTO #temp FROM...

I think it might be easier to answer a question like "Why do we exists or why am I here in this lifetime?".

Without trying to discourage any new commers, performance...

I just had another idea... maybe it can lead you on a new path...

how about using temp tables to build the resultset but with twist :

1st : analyse all...

What's the db name?

Do you use brackets around it (just to make sure to avoid any unforseen bugs)?

Yes...

Another trick that can come in handy for the cases where you need to search like this : '%Y'

You canadd a calculated column like this : ALTER TABLE dbo.tbl ADD...

Thanx for the reply... the weird thing is that half the time it works (when there's no data to display, the iff works, but when the amount is 0, it...