My apologies, that should be OPENQUERY not OPENROWSET.

That's a bit rubbish isn't it. Try this if you get the opportunity. It's only a select, no update:

DECLARE @tsql VARCHAR(8000)

SET @tsql = '

SELECT

E.UCELL_ID As LocalCellID

,RNC As RNC

,Cast( Cast(YEAR_ID...

What...

stevenb 63624 (7/31/2014)

---

Another option is

SELECT *

FROM (

SELECT id

,rowid

,value

,readingdate

,ROW_NUMBER() OVER (

PARTITION BY id

,datepart(hh, readingdate)

,CASE

WHEN datepart(n, readingdate) <= 30

THEN 0

ELSE 1

END ORDER BY id ASC

,readingdate DESC

) PartID

FROM #tempreadings

) a

WHERE partid...

Koen Verbeeck (7/31/2014)

---

Lynn Pettis (7/31/2014)

---

Lynn Pettis (7/31/2014)

---

SQLRNNR (7/30/2014)

---

It could work - depending on what the data is...

WITH DistinctDays AS (

SELECT DISTINCT ID, ReadingdateDT = CAST(CAST(Readingdate AS DATE) AS DATETIME)

FROM #tempreadings

)

SELECT *

FROM DistinctDays d

CROSS APPLY (

SELECT Timeslot = DATEADD(minute,n*30,ReadingdateDT)

...

mallikachowdhary 98955 (7/29/2014)

---

Sure Chris, I'll try this right away.

I would like to share a new learning I made today , earlier when I was trying to run the query with...

patrickmcginnis59 10839 (7/30/2014)

---

Grant Fritchey (7/30/2014)

---

patrickmcginnis59 10839 (7/30/2014)

---

Its sort of a free market thing, if people decide that SO/SE isn't useful, it could go away. I'm hoping it sticks around because...

Thanks for the feedback. Here are a couple of ways of expanding on the number of rows you have to generate:

WITH iTally (n) AS (

SELECT TOP(SELECT TOP(1) [Rows] = COUNT(*)...

How many rows might you...

Sample data setup:

DROP TABLE #Table1

CREATE TABLE #Table1 (id int, value int)

INSERT INTO #Table1 (id, value) VALUES

(1, 11),

(2, 12),

(3, 13),

(4, 14)

DROP TABLE #table2

CREATE TABLE #table2 (id1 INT, value1 INT)

INSERT INTO #table2...

SELECT id, value, id1, value1

FROM #Table1 t1

CROSS JOIN (SELECT TOP(SELECT TOP(1) [Rows] = COUNT(*) FROM #table2 GROUP BY id1 ORDER BY COUNT(*) DESC) n FROM (VALUES (1), (2), (3), (4),...

Greg Edwards-268690 (7/29/2014)

---

bantrim (7/29/2014)

---

Ed Wagner (7/29/2014)

---

Greg Edwards-268690 (7/29/2014)

---

Winter and Road Construction.

In Minnesota, there is a pothole season too.

Plenty of time here too, although I'd venture to say someone taking in...

It's a procedure on the calling server. You have a few options here:

Save the query as a view on the remote server and call the view from the procedure.

Change the...

mallikachowdhary 98955 (7/26/2014)

---

Thanks Lutz for the recommendation...Can you please send the steps or the final query to run.

As it is the production server I'm not allowed to make frequent changes....