Let me see if I understand correctly. You're receiving a comma-delimited parameter and if you have any value different than 0, you'll return a simple result set with no relation...

Alex,

That seems like an easy patch instead of doing a...

Could you use the Data Profiling Task in SSIS?

http://msdn.microsoft.com/en-us/library/bb895263(v=sql.105).aspx

The following code returns a value of 10. Is that what you're after?

SELECT months_between(TRUNC(TO_DATE( '20131101', 'YYYYMMDD'), 'MM'), TRUNC(SYSDATE, 'MM'))

FROM Dual;

Why is it giving a wrong answer? In other words, what would be the correct answer and what are you getting right now?

And here you have a different version that will use only the rows needed. Ideally, you shouldn't have to create the PersonList set and you'll have a table with them...

This might not be the best solution for performance because it will run on all rows. The tricky part is to get the complete list with values in zero for...

Is this thread full of spam? Or is it a real problem with valid suggestions?

http://www.sqlservercentral.com/Forums/Topic1612977-131-1.aspx

I guess I confused what you were trying to say with changing the table you select the information.

As for the second part, we seem to be on the same page....

SimonHolzman (9/12/2014)

---

This is used because <Table 2> has a field that was originally intended to store pointers to different types of data depending on other information and so it is...

This won't help with performance, but it will save you coding time.

You can change this:

DECLARE @FROMDATE DATETIME = GETDATE()

SET @FROMDATE = DATEADD(HOUR, DATEPART(HOUR, @FROMDATE) * -...

I would suggest the NOT NULL constraint as Eugene mentioned, but I would also add a DEFAULT to it.

Christopher Kutsch (9/12/2014)

---

tempdb is always going to run under the native compatibility mode. Add a Use tempdb statement before you call the CROSS APPLY and change the context back when...

gward 98556 (9/12/2014)

---

Thanks Eugene, I just tried your test method and confirmed that this method is SARGable:

WHERE MyNullableCol IS NOT NULL AND MyNullableCol != ''

so there are clearly situations where...

Maybe something like this:

WITH SampleData AS(

SELECT 1 n UNION ALL

SELECT 2 n UNION ALL

SELECT 3 n UNION ALL

...