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...

JohnG (12/4/2008)

---

Note that even in America, extended ASCII is very common. Just think of all of peoples names that have accents in them. Or the word resumé. ...

I'd still try the import wizard... it has surprised me quite a few times. Worst case scenario, you're still stuck at the same place.

Let me get in on that!