Guys,

I think this is an important topic to explore that needs to be easily found. I have started a new thread, can we shunt the discussion to here...

Ooops!

Its not often I get flamed on here and I certainly didn't mean to hijack the thread.

Of all the people who post on here Jeff and GSquared are the two...

This doesn't read like an SQL issue, more a GUI issue.

I may be wrong but it sounds like what she wants is that if the field is NULL then do...

@jason

I don't think so, the default has to be set as part of the DDL for the table and you can't use variables in that situation.

The SSIS package calls...

And that us why MI Developers hate 'lazy' programmers that use EAV tables.

By lazy, i really mean misguided or uneducated. Entity Attribute Variables make ut easy to enhance the functionality...

Thanks Jason, I am going to investigate that option a bit further. It seems to make a lot of sense as it involved only hitting the record once (when...

Whilst we are on the subject, I am not a big fan of sub-selects and co-related sub queries, even though the logic that is implemented is vital in many query...

just a thought, why are they inside procedures and not just a view?

Could you rewrite them as table functions, in which case you can use CROSS APPLY

When you say combined, do you mean that they have the same structure and need to be seen as a single results set in which case you can use

UNION

or

UNION...

I don't know whether these will be giving you a performance hit, but for me the large CASE statements would be a maintenance issue.

In these circumstances I like to create...

The solution is to write the SQL statement as

EXEC ?= usp_myStoredProc ?,?

and set the parameters as Param0 = ReturnValue, Param1 = Input, Param2=Input and assign Param0 to the variable you...

Quick update.

One problem I was having was that I had not renamed the default resultset to 0 to return the first column.

Now I get the error message in the Progress...

Thanks Daniel, I am struggling with this concept... I did as you suggested and get processing errors..

Here is the storedProc that is being called from the SQL task

ALTER PROCEDURE...

Thanks G, as always a font of knowlege.

I feared that would be your answer 🙁

Because I have about 40 tables to import and I already have the format files built...

Yes i had. Bizarrly it started working about 20 minutes after posting and i swearvi didnt change anything. I hate it when that happens!