Costco

Is it possible that you could post the actual execution plan instead of the estimated plan? That will tell us much more. What you posted may not be the plan...

I'm out of time but perhaps this can get you started. You can use DelimitedSplit8K_LEAD (see link in my signature) to parse the string like this:

SELECT ItemNumber, item =...

YES.

I've been a BI Developer/Architect/Consultant for ~7 years and I am a total .NET language novice. Front...

I, too, had a real hard time with this, it took me a long time to find where/how to download Dev Edition. I remember that that key was to be...

Provided you can get away with up to 2 clock_in's and clock_out's per person/date you can do this:

WITH Prep AS

(

SELECT

creation_date = CAST(creation_date...

This should not be hard, I'm looking at this now.

In the meantime, in case people want easily consumable sample data...

SELECT * INTO dbo.test

FROM

(

VALUES ('168780','10148','16477','7/21/2016 15:00','CLOCK_OUT','1','DAY','RICHAR'),

...

Eirikur beat me to it on the POC index - that's always the first thing I look for when a window function makes a query much slower.

I would add...

What you are doing does not make much sense. Perhaps you could post some sample data and your desired results and we can point you in the right direction.

a...

Yay. I got one right.

Personally I'd simplify this one like this:

SELECT

DATEADD(YEAR, N, CONVERT(DATE, v.HolidayDate)) AS HolidayDate,

HolidayName

FROM (VALUES ('12/25/2016', 'Christmas Day')) AS v (HolidayDate, HolidayName)

CROSS...

Lynn Pettis (9/27/2016)

---

mister.magoo (9/27/2016)

---

Lee Hopkins (9/27/2016)

---

I have a script that gives me a string of the columns and types.

I wan to use this result to create a declared table

DECLARE @listStr...

A lot of good advice here, especially

Over the years I have created dozens of...

I have no idea what you're trying to do but it seams simple. Please post your desired results. On a side note -

This:

and (cm.Original like'6%' or cm.Original like '7%' or...

Building off of what Scott said - a table variable is not the best choice for what you are doing because it can't be referenced outside of the dynamic SQL...

For fun, here's another option. This is a function I created a couple months ago which uses NGrams8K[/url]. The function allows you to grab everything between the m^th and n^th...