<shudder>

It becomes rather scary when seen in context...

duplicate post. no replies please. Discussion already started here

Please provide table DDL and sample data in a ready to use format as described in the first link in my signature as well as your expceted output based on...

I would use a three-step scenario:

Step1: use the DelimitedSplit8K function referenced in my signature with delimiter ','

Step2: using the result set, apply the DelimitedSplit8K function with delimiter '='

Ste3: Use The...

I'm expecting there's a users table...

SELECT

t2.usr,

SUM (CASE WHEN t1.createdby =t2.usr THEN 1 ELSE 0 END ) AS created,

SUM (CASE WHEN t1.updatedby =t2.usr THEN 1 ELSE 0 END )...

Another option would be to use a calendar table with the columns you need and join to that table.

A calender table is especially helpful if there are special date ranges...

reported as well. There are about 100 of those within the last few hours from the same user. :sick:

spam. reported.

Spam. Reported

bcchamberlain (2/23/2012)

---

I have tried this code and it works great, but I am having some difficulty with the name spaces. I am trying to get the the submitter name, but...

I didn't try to convert the numeric value to a date value.

But here's my approach:

DECLARE @tbl TABLE

(

ROW_NOINT IDENTITY(1,1),

idINT,

CHECKS INT,

duration INT,

id_date INT

)

INSERT INTO @tbl

VALUES

(85036024,21504,10,40544),

(85036024,4337731,10,40545),

(85036024,269731,10,40548),

(85036024,269731,10,40549),

(85036024,269731,10,40552),

(85036024,21504,10,40553),

(85036024,21504,10,40554),

(85036024,21566,10,40555),

(85036024,21506,10,40556),

(85036024,21506,10,40557),

(97393064,21504,11,40558),

(97393064,21504,10,40562);

WITH cte AS

(

SELECT

*,

ROW_NUMBER() OVER(ORDER BY Row_No)-

ROW_NUMBER()...

To answer this question:

It depends on the code behind the split function. As long as it is not an in-line-table valued function, the answer most...

I've been talking about replacing the view with an itvF.

And yes, you can call the itvF with a parameter that is used inside the function.

You can't mark it as answer here at SSC. The concept over here...

You could also move the WHERE clause into the view definition (assuming the 10 minute interval is a fixed value).

If the time interval is a variable, I would consider using...