Steve,

well done for highlighting the issue and handling it so well. As a coder, musician, and budding author (!), I'm all too aware of copyright, "fair-use", and reinterpretation laws...

I don't know if its valid, but, convert(float, round(1.135, 2)) yields 1.1399999999999999

Is there a lesson in this for us? Do the conversion last of all?

pk

Hi KS,

Where I work we use views mostly for reporting purposes. We use Crystal Reports as the front end, and rather than using Crystal to define the query, we...

Alamir said:

> yes Join is made more faster ... because it join 2 tables more 

> faster (Pk and Fk)

Which is true, providing you are joining on defined keys. If you...

Ok, first some sql theory. A join is another (faster) way of doing a where clause between two tables. So where you say:

SELECT susg.sysusergroup_id, sg.sysusergroup_name

  FROM sysuser_sysusergroup susg, sysusergroup...