Search results

THAT is an approach I have never considered or seen. In my line Ive not needed I dont think, but its very very clever. Legacy DTS was far better at getting data types right rhan Ssis. It cheated a bit by assuming long variable data types. SSIS i change the sample data size to some 1000s...

Yeah feel your pain, Ive been using DTS since SQL 7 and SSIS since 2005 for getting spreadsheets or whatever into dbs, mostly for contact centres, etl is my main focus with some qliksense or ssrs historically if I had to do front end, Intrigued on your patent way too. Ive just about got...

Some of the ridiculous formulas they had on spreadsheets at my place, total CPU burners. People would open them and sit there whilst calculations were updating and all their cores would max out for 15 mins Ive changed the whole place to pretty much run on views I write on a sql server on a...

Corrected

Countif? Sorry that's probably a crap and obvious reply. Tapping away on phone, Im sure someone will have a solution for you quickly clapham gulls very handy in Excel IIRC