Could you post an expand example to work with?

Hello? Any feedback?

If you use a single table for each day the tables will be smaller.  You would only need 31 tables for the data as 30 of the tables are used...

Quick question as I am getting ready to head out from work and may not get back on a computer until work tomorrow, the GraphDB Microsoft added in SQL Server...

The other thing, that Jeff hasn't said yet, check the dynamic code that is being generated as well as how it is being executed.  I solved some of our dynamic...

Two ways to accomplish this and it depends if you have Enterprise Edition or not.  If not, use partitioned views.  Each day is in its own table and you rebuild...

Not sure, the following works for me:

declare @ssGrade VARCHAR(8000) = 'PK,KG,01,02';
SELECT * FROM fn_splitString(@ssGrade);


Doing the insert into a temp table works as...

I really don't like importing data from Excel spreadsheets.

How about something like this:

DECLARE @SQLCmd NVARCHAR(MAX),
        @Sheetname NVARCHAR(128) = N'Sheet1$',
        @sql NVARCHAR(MAX) = N'
SELECT * into TestClient FROM OPENROWSET(''Microsoft.ACE.OLEDB.12.0'', ''Excel 12.0;HDR=YES;Database=G:\CustomerETL\Employee\PendingETL\ETLEmployeexls.xls;'', [@Sheetname@]);