Search results

Is it possible to declare and use a varible in a select statement? Is there anyway you can use a varible in a select statement in SQL? Reason i ask is because i have a very complect calculationin the select statement and i need to work out percentages still. Whole query below. SELECT...

Hi... I am currently trying to read the checkbox value from a field in a table and do a calculation using the data. If the checkbox is checked then i charge a weekend rate, if it isn;t checked i charge a weekday rate...