"detailed analysis" for me is when the root causes are analyzed and solutions are provided to address them (e.g. using validation on the database side, uniqueness constraints, etc.) . You...

Doing basic prevalidation before calling a validation service seems to be an acceptable approach. Personally I try to avoid building too much logic in a validation. If a rule can’t...

I think the postcodes aren’t the best example in what concern the data quality assessment rules. Even if one succeeds in his attempts of reengineering the postcodes rules, by next...

This might work, now it depends what meaning the 0 value has for you:

select *

from someTable

where IsNull(someTable.Value, 0) = @myParam

Thank you Bob, we have similar perception on the "definition" of each type of function.

Best regards,

Adrian

Sorry, I don't want to enter in any conflicts related to terminology (or of any type) as meaning is highly dependent on context, communities and is in continuous change. It's...

Of course a dynamic script can call an inline table-valued function, though, as far I know, a dynamic script can't be run from an inline table-valued function because neither EXEC...

I observed that L. Van Staalduinen and JDCook73 already approached the case of attributes with NULL values, therefore I hope I'm coming with something new.

I'm using both approaches based...

Hi Dixie,

thank you for your detailed answer. I understood the reasons. Sorry, I haven't seen the fragment where was mentioned that other solutions might exist!

...

Hi,

Normally for such a query could be considered also the correlated subquery versions:

select s.*

from dbo.SalesDetail s

where exists (select 1

...

I was wondering why you haven't used the CROSS APPLY operator for the first query (see below), any special reason for that?

SELECT a.quote_date

, a.close_price

, dat.[20_day_sma]

FROM #google_stock a

...

I prefer to use GROUP BY when I want to see the number of duplicates for each group of attributes used to check uniqueness, while ROW_NUMBER is a nicer solution...