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...

It depends.

I have seen this done both...

erouse (9/21/2016)

---

Jeff Moden (9/16/2016)

---

erouse (9/16/2016)

---

Can somebody please help? Is there a fairly simple way to do this?

This is my data now.

LABORLC

152685A B C D E

152969A B

This is what...

What Nicholas proposed will work provided that CN= always comes before OU=. Working with AD, I've see that this is not always the case. If this is how it is...

dbodell (9/20/2016)

---

You know that is an interesting comment because I recently changed the code to use MERGE instead of separate INSERT and UPDATE processes. Removing and rebuilding the indexes was...