Rumours are that MONEY will be deprecated in a future version or incompatible with other db migration.

So l'll probably use decimal and

decimal (19,5) instead of (19,4) for exchange rate...

Btw I've converted an access db to sql server and SSMA access convert to float...

thanks !

I just read about money and decimal (19,4) Nobody seems to have the same answer about what the best data type...

thanks exactly what I wanted but now I've 2 good solutions, computed and cross apply solutions

you are the best(all) !

wow thanks I just tried some test on computed columns... Sql server is so strong 🙂

thanks again

Yean but I want to avoid to repeat PrdCmd.Prix * PrdCmd.Qte so many times. This expression is simple but if it become pretty long and I need to change base(prix*qte)...

thanks everyone for input

Last question:

I've a query(french query) WORKING IN Access but NOT in Sql Server 2012 express...

SELECT PrdCmd.NoCommande AS NoCmd

,PrdCmd.DATE

,PrdCmd.Qte AS q

,PrdCmd.Prix AS p

,[p] *

AS Column1

,[column1] *...

Yeah I know but my fields name are pretty long so it become hard to read in my query because I've around 15 fields to retrieve with many calculated long......

I'm looking for an hour and after posted my question I finally found my answer...

select q*p as t , p,q from(

SELECT PrdOrder.Qte AS Q, PrdOrder.Prix AS P

FROM PrdOrder) as PO;

There are a date field, customer# field and even other fields. I want to keep it simple for the example

For quebec it's

(GST * amount) + (PST * ((GST...

wow dwain.c thanks exactly what I wanted sql server is so strong and both of you 🙂

I'm learning sql server and I'm trying to convert access back-end to sql...