INSERT INTO #myTable

(date, companyID, industry)

SELECT '20000430', '2', 'Corporate' UNION ALL

SELECT '20000430', '2', 'Corporate' UNION ALL

SELECT '20000430', '2', 'Corporate' UNION ALL

SELECT '20000531', '2', 'Corporate' UNION ALL

SELECT '20000531', '2', 'Corporate' UNION ALL

SELECT...

Using SQL Server 2012, Visual Studio 2010 shell

Yes, user would be executing from SSIS, or executing package from Window Explorer.

This worked great Thank you!

Awesome thanks! 50K is a bit much, will probably look for something more budget friendly...

Thanks for response Eirikur,

Ideally it would be a machine that would have between 4-8 users connect to the server/machine.

It would be performing complex DAX calculations where most likely materializations and...