Without DDL and example data I can give only a generic answer. But something like

select t1.*

from t1 left join t2 on (t1.f1 = t2.f1 and t1.f2 = t2.f2 ...)

where t2.f1...

Or provide an additional parameter and use a sp as the report's source to handle the selection in any way you wish ...

Did you try my suggestion - if so, did it fail? What error did you get?

Otherwise, please explain your reasons for not wanting to try.

I haven't tried, but maybe you could use a view for the source of your data.

NLV (6/13/2011)

---

Hi,

I want to fetch the data from ERP database thru SQL query. I want to know how to connect to ERP database to retrieve the data in to my...

I'd like to see that. Please provide details of how the FST can create Excel...

Randheer (3/13/2011)

---

You should be prepared before going to the interview and I believe there is no harm if you know what you are ignoring while doing your regular work.

so get...

I'm interested to know how you avoided getting a meta-data error as a result of the expected columns being missing on the dodgy row?

It would be useful to know why though, as it's an unusual request. Instead you have avoided the question and simply restated your original post.

select Coalesce(NullIf(CurVal5,0), NullIf(CurVal4,0), NullIf(CurVal3,0), NullIf(CurVal2,0), NullIf(CurVal1,0))

should...

I've tried, but I don't know what that means. Is there a date in there from which to determine 'last'? Is...

alexanderbebe (6/9/2011)

---

it is 2003 excel file. yes i gave without quotes.

Later, i tried by renaming the excel file from xls to xlsx but i am getting the error as "Could...

Please include a screen shot of the control flow - perhaps just after it has failed to demonstrate where it failed.

Also include the text of the error.

Have you considered using SSIS to do this? It could handle the commits as you wish.

Thanks for the blog link - I learnt something useful today.