You might want to try the CrossTab method described in the related link in my signature.

It's easier to read, usually performs better and is more flexible (easier to change to...

Glad to help, Wayne 😀

SET DATEFORMAT MDY;

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

--...

I would use a Windows scheduled task with the related sqlcmd.

I would use a CTE together with ROW_NUMBER() OVER(PARTITION BY SensorID ORDER BY DateTime) AS row and do a self (outer?) join on it based on Sensorid and cte1.row=cte2.row-1

If you...

Will something like this help:

SELECT *

FROM Students s

CROSS APPLY

(

SELECT

(

SELECT *

FROM Students t

WHERE t.DisplayName = s.DisplayName

FOR XML RAW

) x1

)x

Something like this?

DECLARE @tbl TABLE

(

idtype CHAR(1), id INT, VALUE INT

)

INSERT INTO @tbl

SELECT 'A', 1 ,0 UNION ALL

SELECT 'B', 2 ,1 UNION ALL

SELECT 'B', 3 ,1...

Would you please clarify your requirement? What would be the criteria to do the aggregation?

Based on your rather vague example it seems like you want to count the rows with...

Using Perrys sample:

SELECT RIGHT(CONVERT(CHAR(8),@dtime,8),5)

It depends.

What's the data type of routing?

As a side note: is there a specific reason for that heavy usage of IN clauses instead of joins or CTEs?

You could convert it to integer to use it for aggregation:

MIN(CAST(YourBitCol AS TINYINT))

or the lazy-dev version:

MIN(YourBitCol + 0) -- force an implicit conversion

Edit: @Gail: the echo was not intentional...

Steve Jones - Editor (9/28/2010)

---

LutzM (9/28/2010)

---

If you're a customer/client: How often did you have a chance to talk to the dev team directly to clarify your requirements (or what you...

Sounds like parameter sniffing[/url]. Please follow the link and read all three related articles. It's well worth it!

mstevens92 (9/28/2010)

---

Probably doesn't help that I haven't touched SQL in about 6 months, been up to...

Steve Jones - Editor (9/28/2010)

---

I am not sure I've had many projects at all in my lifetime that were on budget/on time unless they were trivial (< 1 week). It...

CirquedeSQLeil (9/27/2010)

---

Very interesting. I have learned something new.

Even with an explicit deny on the table for update, delete, and insert as well as the denydatawriter - the user that...