The same 403 error when you browse to it in Comodo Dragon, so I suspect Gus is right and you have a cookie already on your machine.

I was going to...

Bit of a guess.

SELECT activity, oldSponser, oldSibling, newSponser, start+rn AS newSibling

FROM (SELECT activity, sponsor, sibling, 4, ROW_NUMBER() OVER(ORDER BY activity)

FROM @activity

...

Create a table, then change this: -

EXEC (@SQL)

SELECT @SQL

To this: -

INSERT INTO yourTable

EXEC (@SQL);

If you're doing this to learn the syntax for a cursor, then ignore the next part of...

Just to expand upon Mark's answer, I think you want this: -

WITH Recur AS (SELECT TaskID, Task, BaseTask, BaseTaskID, BaseTaskInterval, 0 AS taskDays

...

Depending on what you want to group by, you want something like this: -

SELECT Levels_ID,DATEADD(HOUR, DATEPART(HOUR,Reading_Date), DATEADD(DAY, 0, DATEDIFF(DAY, 0, Reading_Date))) AS Reading_Date,

SUM(fuel_level),SUM(fuel_temp),SUM(fuel_volume)

FROM (

SELECT Levels_ID,Reading_Date,fuel_level,fuel_temp,fuel_volume

FROM (

select Levels_ID,Reading_Date,sum(Fuel_Level)as fuel_level ,sum(Fuel_Temp)as fuel_temp,sum(Fuel_Volume)...

I guess that this is what you're after.

CREATE PROCEDURE sp_hrdate @red DATETIME AS

BEGIN

DECLARE @Reading_Date DATETIME;

SET @Reading_Date = @red;

SELECT...

Try this instead of your cursor: -

UPDATE TEM1

SET GPS_DIST = ABS((GEOGRAPHY::Point(A_FGLAT, A_FGLONG, 4326)).STDistance(GEOGRAPHY::Point(B_FGLAT, B_FGLONG, 4326)))

FROM (SELECT A.HUL_OUTLET_CODE, A.FGLAT, A.FGLONG, B.FGLAT, B.FGLONG

FROM TEM1 A

...

Please include definition of table "dbo_40" and sample data for it that replicates the issue you are facing, see this article for how --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Here's the code you posted but...

Note: I'm from England.

I was once taken aside by a manager and told off for pronouncing "router" as "root-er" to one of our American clients. I was told that it's...

I could, but I'd rather hear what you think then explain it to you if you're wrong.

Let's break down what your stored procedure does: -

* Your stored procedure begins

*...

dwain.c (8/31/2012)

---

Actually, no I didn't test the rCTE, mainly because I think you said you didn't think it would perform too well. So I took your word, making the...

This is identical to Andy's query, I just find it easier to read. Just a preference thing 🙂

SELECT COUNT(machine_id), [Month]

FROM (SELECT machine_id,

CASE WHEN...

Add

SELECT * FROM @TMP1

Just before the "END".

Sorry dwain, but that smacks way too much of the stackoverflow method for answering questions. Since I hate the atmosphere over there, I...

It's a real shame that you've decided not to post the requested DDL, sample data and expected results based on the sample data provided. I'd have really enjoyed showing...