In scientific applications you care not about number of digits after decimal point but about precision, about trusted digits in a value.

Did you ever had problems with adjustment of money...

No, the value in record is saved as FLOAT.

Closest float value to 33.87 is 33.8699999. Actually this is not right, there must be 5 more "9"s in the stored value:...

The article from BOL:

--------------------

float and real

Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can...

I don't have SQL 2005, so I cannot test your fuction against my example.

What I'm trying to say this task is not just about replacing text between "" including these...

Did you read your own first post?

> My Problem is the following:

> I have two tables. I need to get records from the second table where a key

> field...

Charbel, never forget you are working with RELATIONAL DATABASE.

It's built on relations between entities.

If you don't establish relations between your tables then forget about SQL Server. There are plenty...

Hope your joins are right.

Try this clause:

WHERE c.b2 = @Criterion OR @Criterion = ''

If I understand your requirements correctly...

Can you explain the method you are using to import data without inserting it into a table?

Every note or coin is placed into a slot also only once. And is...

If you'll do update during INSERT you'll do it ONCE and FOREVER, not once per day.

And UPDATE will affect only new data, not the whole set.

And if your import will...

If you care about performance you must fix database design.

Left(table1.,2) = Left(table2.,2)

will cause table scan (twice) with following hash join.

It will create #Table in tempdb with 100k*100k=10bn rows.

You need to...

For normal simple mind people (like me, for example) everyone who understands regular expressions so well is kind of gremlin.

And you are outrageous...

Try this:

DECLARE @Text varchar(8000)

SET @Text = '"X<5"'

SELECT dbo.fnStripHtmlTags (@Text)

Remove space in "< Condition".

It's a simple "copy-paste" mistake.

You should take care of such things by yourself. It's too obvious.

ON t2_1.PID = t2_max.PID

AND t2_1.PayAmount = t2_max.max_PayAmount

You did not build "According to the posting suggestion".

You duilt differently.

Try again and now pay attention to details.

Maybe other people will have different opinion , but I'm not amongst them.

Those are different things, used for different purposes.