Alan.B (10/14/2016)

---

Luis Cazares (10/14/2016)

---

Here's a simple option using the DelimitedSplit8k that can be found here along with its explanation: http://www.sqlservercentral.com/articles/Tally+Table/72993/

A specific function could be made to split only on the...

Here are 2 modified versions of the DelimitedSplit8k function. The second one will only work on 2012 and more recent versions.

CREATE FUNCTION [dbo].[DelimitedSplit8KNOccurrence](@pString [varchar](8000), @pDelimiter [char](1), @pOccurrence int)

RETURNS TABLE WITH...

jasona.work (10/14/2016)

---

Sean Lange (10/14/2016)

---

Amazing!!! That "answer" is as vague...

Here's a simple option using the DelimitedSplit8k that can be found here along with its explanation: http://www.sqlservercentral.com/articles/Tally+Table/72993/

A specific function could be made to split only on the 7th delimiter and...

I know why do you get an infinite loop. I won't post the solution, because you would keep the loop and ignore Sean's advice.

Alaster07 (10/13/2016)

---

@Sergiy

I tried your approach, and it kind of mostly works. The issue I am running into is that the "early" times will all be at the front of...

Grant Fritchey (10/13/2016)

---

Sean Lange (10/13/2016)

---

WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.html

This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or...

Changing subject here.

Has anyone else had problems with the site being slow or fully unavailable since last night (American time)?

Ed Wagner (10/13/2016)

---

jasona.work (10/13/2016)

---

Geez, '73 I think...

I really hope the OP didn't depend on the last replies. Not because they're bad, but because it's been over 3 years now.

mr_xtant (10/12/2016)

---

I am verifying the space used by using Management Studio, right clicking on the table object in question, choosing properties, and looking at storage. So far, nothing has worked,...

Here's an alternative that should be faster than using a scalar function. It includes an example on how to use it.

CREATE VIEW vNEWID

AS

SELECT NEWID() AS _NewID;

GO

CREATE FUNCTION GenerateRandomDateTime

(

@MinimumDate DATETIME,

@MaximumDayDifference INT,

@MaximumSecondsFromMidnight...

mareynolds (10/12/2016)

---

Good afternoon. I need some assistance getting pointed in the right direction. My ultimate goal is to produce rows where there is not a matching courseinfo.coursestatecode in the responsibility.subjectcode...

Sean Lange (10/12/2016)

---

Grant Fritchey (10/12/2016)

---

jasona.work (10/12/2016)

---

Now this sounds like it has an interesting story behind it...

Grant Fritchey (10/12/2016)

---

I'm the guy who helped a developer send porn to our client list...

And here's an example based on that article (you'll need to complete it):

SELECT machine_id,

type_id,

MAX( CASE WHEN attribute_name LIKE 'issuer%' THEN attribute_value END)...