# Search:

Type: Posts; User: Dwaynewayne

1. ## Thread: convert currency sql

by Dwaynewayne
Replies
3
Views
3,903

### Re: convert currency sql

thank you very much thetimmer
2. ## Thread: convert currency sql

by Dwaynewayne
Replies
3
Views
3,903

### convert currency sql

(
@Amount DECIMAL(18,2),
@Freight DECIMAL(18,2),
@FreightName VARCHAR(500)

)
AS
SELECT FreightName,

CASE WHEN (FreightName= @FreightName) And (UseFreight = 'TRUE') THEN
3. ## Thread: calculate from data table

by Dwaynewayne
Replies
8
Views
3,326

### Re: calculate from data table

yes that is what i want just the value in the row what i dont want to so is every time i add a new row i have to write a line of code
i am pretty much a newbie to this i am about a week in to...
4. ## Thread: calculate from data table

by Dwaynewayne
Replies
8
Views
3,326

### Re: calculate from data table

i am in to shipping of cars and there are ways and mean of transporting them. if i am going by sea i use CIF, CFR, FOB
CIF mean i bought the with freight and insurance into the price. so my...
5. ## Thread: calculate from data table

by Dwaynewayne
Replies
8
Views
3,326

### Re: calculate from data table

no the text box wont be left blank it will always have a value the reason it need to be 0 if check in case some one place a value in the check box it will turn it in to 0 as that CFR mean the freight...
6. ## Thread: calculate from data table

by Dwaynewayne
Replies
8
Views
3,326

### calculate from data table

'i have a tblFreightdataset with the following Coloum and row
ID FreightType Value FrightValue
1 CIF 0.00 []
2 FOB 0.015 []
3 CFR 0.015 ...
7. ## Thread: filter to find between value in two column from the same row

by Dwaynewayne
Replies
5
Views
623

### Re: filter to find between value in two column from the same row

your first suggestion work what i had wrong was my table was set to varchar(50) and not int so after i change it then it was good thanks again
8. ## Thread: filter to find between value in two column from the same row

by Dwaynewayne
Replies
5
Views
623

### Re: filter to find between value in two column from the same row

it did not work can a if statement be us?
if i change the following it work but i want ti be able to change the number value from a text box
SELECT Importer,Fruits, ValueFrom, ValueTo
FROM...
9. ## Thread: filter to find between value in two column from the same row

by Dwaynewayne
Replies
5
Views
623

### filter to find between value in two column from the same row

my dataset is as follow

Importer| Fruits |ValueFrom |ValueTo
Mark Banana \$1 \$10
Mark Banana \$11 \$20
John Banana \$1 \$10
John ...
Results 1 to 9 of 9