Remi, if Cost1 is NULL you function will always return NULL.

IF @Cost2 < @ReturnValue OR @ReturnValue IS NULL

will fix it.

SET @cmdString = 'bcp "EXECUTE ' + DB_Name() + '.dbo.YourSP ''' + @Param1Value + ''', ''' + ...  ''', ''' +  @ParamNvalue + '' ' " queryout

1st.

DO NOT CONVERT DATETIME TO VARCHAR!

2nd. If after serious consideration you'll decide you neet to convert to varchar,

DO NOT CONVERT DATETIME TO VARCHAR!

3rd. If anyway you must to convert it to...

SELECT MIN(NEIGHBORHOOD_CODE)

FROM (SELECT NEIGHBORHOOD_CODE

                 COUNT(NEIGHBORHOOD_CODE) AS TOTAL_RECORDS, 

          FROM SFCVB_NEIGHBORHOODS

          GROUP BY NEIGHBORHOOD_CODE)

WHERE TOTAL_RECORDS > 1

Query system tables.

Select t2.Date from Table2 t2

   inner join Table1 t1 on t2.date between t1.DateFrom and t1.DateTo

GROUP BY t2.Date

ORDER BY t2.Date DESC

What do you mean "precise"?

There is no such thing in math. There is only number of precise figures.

Float has 53 precise figures, decimal precision depends on it's value. 25 as...

No, it does not.

But in composite index it's better to have strongest restriction first.

In your case index (address_id, address_type) will be used much more likely then (address_type, address_id).

Of course, it...

What you are trying to store in DECIMAL(38,6) what cannot be stored in FLOAT?

Precision of FLOAT is 53 digits and size 8 bytes.

If you nees fixed comma you can covert...

And better create index on this computed column. Clustered, if possible.

Clustered index is the best option for selecting range of data.

> If we do not know his middlename then he does not have one.

If we do not know his middlename then it DOES NOT MEAN he does not have...

Originally t1.Data was expected NULL in some returned rows.

But in the last query t1.Data cannot be NULL, t2.Data takes its place.

This changes direction of the join.

Author just did not follow his own logic.

On the first page he wrote:

I expect to see the following when I filter the data such that T2.Data=2 and T1.Data=5

T2.Data,T2.ID,T1.Data

2,1,5

2,2,5

2,3,NULL

And on this...

How many topics about this matter we must have?

SELECT     t2.data,t2.id,t1.data

from table2 t2 left outer join table1 t1

    on t1.id=t2.id and t1.data=5

where t2.data=2

Having "t1.data=5" in where clause you eliminate NULLs and make it INNER JOIN.