I got a 3th party tool that fetches the data via my api key from the game server.

The developer recently made some changes to the structure of the api, but...

I had a mirroring up one time to test how that worked but it's been inactive for months now and the reports always got generated from the original.

Which was odd,...

Closing and reopening doesn't help, I notice now that most recent data gets loaded but like 2-3 hours after that data was inserted/altered.

Rebuild

Sorry for this late response I've been buried in an urgent project.

No I haven't scheduled the reports yet, its in the report designer in Visual Studio where it stopped collecting...

In a personal database project I've been using a temp tables in all my udf's cause I need results that I can't generate with my current tables.

That's the path I've chosen and with a cte I managed to get part of the data I want, it allso gives me the opportunity to make some further calculations.

I...

declare @pi varchar(20)

declare @piid int, @pil int

set @pi = 'Enriched Uranium'

select @piid = PIMatID,@pil = PILevel from planetaryInteraction.PIMaterials where PIName = @pi

print @piid;

with PlanetI(PIMatID, PIName, PILevel, IsChild,AmountNeededNextLevelOne,AmountNeededRequestedLevelOne,Level,Cost)

as

(

select pim.PIMatID, pim.PIName, pim.PILevel,...

Ok explanation & code

In EvE Online everything you can buy and sell on the markets are items created by the players, by either mining or processing raw materials.

A while back...

Well to answer bluntly (no offfence) there is no way to learn it from the metadata.

temp tables are created in the TempDB, they are owned by it and are part...

It might have worked for you for a while, but remember for others who haven't worked on it can be confusing if the code you give references to tables that...

Ah ok

so there is no inserted table.

So where does Inserted fit into the picture

I will not go so far as to yell at you, but this is a question which answer can be found almost every lesson 2 of sql.

So the trigger looks like this

CREATE TRIGGER trig_Consumables

ON ReceiveOrder

FOR UPDATE

AS

BEGIN

UPDATE Consumables SET Quantity = U.Quantity + I.q1 FROM Consumables U INNER JOIN Inserted I ON U.Product = I.Product

END

It will be...