You're doing just fine, Craig.

Craig, you can check the values of the variables:

DECLARE @startDate datetime;

DECLARE @enddate datetime;

SET @startDate = dateadd(year, -8, dateadd(day, datediff(day, 0, getdate()), 0));

SET @endDate = dateadd(year, -1, dateadd(day, datediff(day, 0, getdate()),...

Transaction no.? As in named transactions?

It depends upon the scope of your requirement....

According to BOL, NEWID() "Creates a unique value of type uniqueidentifier."

Greg Edwards-268690 (1/13/2010)

---

Grant Fritchey (1/13/2010)

---

Yep. I agree. As soon as it was...

ifila (1/13/2010)

---

Lynn Pettis (1/13/2010)

---

Could you please explain what you are trying to achieve? What is the business case for this query (now I'm starting to sound life Jeff Moden)?...

Using 2005, pulling relevant rows from the linked server into a #temp table can dramatically improve performance.

SELECT key, name

INTO #Remote

FROM serverA.dbname.dbo.tablename

UPDATE FROM with a JOIN can be unpredictable if...

glen.wass (1/13/2010)

---

Thanks Lutz,

i have worked out a method for doing this now,

Step 1 create table with all my results in it, 2 create update table

step 3 create cursor to insert...

Here are two queries which will do the trick.

Both use a tally table to transform the segments within the column into rows, then use a GROUP BY

to dedupe. To...

ROFL! <<unprintable>> 😀

Thanks Paul, that made the long slog into work through the snow very worthwhile!

nialltuohy (1/12/2010)

---

Chris,

Thanks, i know it does but i have one small problem, i also need the savings to be split into 4 columns, for example a policy savings column, building_savings,...

nialltuohy (1/12/2010)

---

Thanks for the reply, this very nearly works thanks very much appreciate it, the problem with the reports i have to use unfortunately is that they wont process multiple...

Something like this?

/** Getting Total Savings per Policy*/

Select 'Policy' AS Sector,

subpolicy_name,

'' AS building_name,

'' AS floor_name,

'' AS room_name,

SUM(CO2_savings) As total_savings

From #CO2temp

group by subpolicy_name

UNION ALL

/** Getting Total Savings per...

José.Cruz (1/12/2010)

---

Hi,

The problem is that the description field is diferente, for instance for machine topdubctx02 you get 2 rows in the result:

TestDate description machname

---------------------------------------------------------------------------------------------

2010-01-07 18:07:45.000 AV Status: Up-to-date 07/01/2010 18:04:29...