sifar786 (7/5/2014)
the above queries work fine in sql server now, but donot know how to automate job schedule to scan network folder for csv files and run those queries on the csv files.i think i should not go ahead with PIVOTING the 2 tables that are produced after running the above queries on the csv file, but rather work with those 2 tables themselves as they contain all the KPI's starting after column 'EAN'.
BTW, as per your earlier suggestion, i am reading on cubes and think they might be the right approach - however, donot know how to create a cube from a single denormalized table containing everything, but not having a primary key.
please advice.
here is one method for bringing files into SQL.........
in one of your previous posts you mentioned passing parameters back to a SQL sproc from excel.....
http://sqlwithmanoj.wordpress.com/2009/09/24/create-parameterized-excel-refreshable-reports/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day