Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i need to calculate ratio between :
Number of cars in sql is :
SELECT * FROM table WHERE Type= 'car' and date='2017' (i need this in script as Number_cars)
Number actif cars in sql is :
SELECT DISTINCT (Machine) FROM table WHERE Type= 'car' and date='2017' ( I need this in script as Active_cars)
Thanks for help
ODBC CONNECT ....
or
OLEDB CONNECT ....
Number_cars:
SQL SELECT * FROM table WHERE Type= 'car' and date='2017';
Active_cars:
LOAD Machine as Active_cars;
SQL SELECT DISTINCT Machine FROM table WHERE Type= 'car' and date='2017';
Hello Jonathan,
I already loaded previously these fields : Type and date and Machine to do some works,
no i need after that add script code like the two transactions
stalwar1 any suggestions please?