BETWEEN has a very nasty habit of dropping records. I don't use it at all. I prefer Greater Than / Equal and Less Than or the reverse. ...

Frank,

Hmmm. Multicast doesn't like being put after my Merge. It comes up with a totally blank screen on both sides of the divide. Apparently it can't see...

Actually, I think Matt just hit it. I don't know why I couldn't see that. It's sitting right in front of me.

DOH!

Thanks, Matt. I think that'll work.

As...

Honestly, it sounds like the function is simply not reaching the first statement. It sounds like it's always evaluating the ELSE when other people run it.

Which doesn't make sense...

Michael,

You've almost got it.

I don't want to use option 1. I have too many records and I want to keep the column width down to what's necessary. However,...

Ann,

Can you post the table structures and some sample data for each table? This would help us help you test it.

And there's no actual physical table by the same name that might have different values than the function uses?

EDIT: And have you tried the stored procedure without a CTE? ...

Unfortunately, since I don't have the table structure you do (or the data), I can't test this. Have you verified the Execute permissions on the Function?

And is there another...

Given what BOL says about functions and variables, Frank's statement makes sense to me. Try building your function SELECT as a dynamic SQL Statement.

Do you know how to do...

Oh, and it just occurs to me. Don't import the data. Use an Execute SQL Task on the Control Flow. Easiest and simpliest way to do what...

FYI, Microsoft is threatening to discontinue the version of JOINing that you just posted, so you might want to update it to the format most people use these days. ...

BTW, BOL has this to say about Table Valued Functions:

Books Online:

Specifies that the return value of the table-valued function is a table. Only constants and @local_variables can be passed to...

I'll look at the proc in a moment, but in regards to getting your table valued function to run in SSIS, what T-SQL do you use to get it to...

Does it look like a Connection Manager issue?

If so, go to connections. Choose New Connection->SMTP (Connection Manager for the Send Mail Task). A popup box will appear. ...

Please give us an example of the data from each of the tables and the conditions you're trying to pull the data together with. It's hard to answer your...