Mark-101232 (3/14/2013)

---

Eugene Elutin (3/14/2013)

---

"Looks like" - it just really "Looks like" nothing more. That is whole problem for recursive CTE's - they are fine for limited number of recursions, they...

"Looks like" - it just really "Looks like" nothing more. That is whole problem for recursive CTE's - they are fine for limited number of recursions, they not very well...

Not really. Quite slow one, actually. But will suite to the purpose...

or you can use something like this:

DECLARE @time TABLE (StringTime VARCHAR(6))

INSERT @time

SELECT '112345'

UNION SELECT '12345'

UNION...

What do you mean by "sequential"? These LogTimes are for the same UserId, they are unique and they grow in its...

Cause some log data can be a bit different.

Try this one:

SET DATEFORMAT dmy;

CREATE TABLE #Source (LogIndex int, UserID nvarchar (10), LogTime datetime, Tipo smallint);

CREATE TABLE #Temp (LogIndex int, UserID nvarchar...

Is your boss SQL Server professional or just an idiot with a lot of ambitions?

For what you're...

david.ostrander (3/13/2013)

---

Hello -

I created a Store Procedure to have Table A sync with Table B by doing an insert of the data that it does not have.

The issue I'm...

declare @filename varchar(100)

set @filename = 'Notes_20130204_003015.txt';

select PARSENAME(replace(@filename,'_','.'),4)

select PARSENAME(replace(@filename,'_','.'),3)

select PARSENAME(replace(@filename,'_','.'),2)

select PARSENAME(replace(@filename,'_','.'),1)

ChrisM@Work (3/13/2013)

---

Hahahaha!

I didn't say it would be faster, but...

Still running after 12 minutes.

Some one around was looking for CPU killer query... I need to cancel that one!

Let's try on 1,000,000 rows:

common test data setup parts:

SET DATEFORMAT dmy;

CREATE TABLE #Source (LogIndex int, UserID nvarchar (10), LogTime datetime, Tipo smallint);

CREATE TABLE #Temp (LogIndex int, UserID nvarchar (10), LogTime...

Yep, that is right now.

And it does look less code. But...

Cause it's based on recursive CTE and hidden triangular join (via cross apply), it's performance very unlikely be on...

ChrisM@Work (3/13/2013)

---

01552 is correct, 01551 is incorrect:

;WITH OrderedData AS (

SELECT *, seq =...

I'm sure you didn't mark rows to be "ok" for UserId 01552 correctly, please check carefully!

SELECT IDENTITY(INT,1,1) RID,*, CAST(NULL AS BIT) AS Flag INTO #Work

FROM #TEMP ORDER BY UserId,...