After more than 18 month the advice is still true... I'm not sure if...

Something like this?

SELECT sitPosition

FROM mfSitPosition

WHERE sitDateTime >DATEADD(MI,-30,GETDATE())

What exactly is your question?

You might want to translate it into English...

The easiest way would be using a normalized table structure: Teams(TeamID,TeamName),Avtivities(ActivityID,ActivityName), and a table to join both: TeamActivityDays(TeamID,ActivityID,Day) (There are most probably people out there having the opinion to need...

What do want to do with the rows in your c.u.r.s.o.r.?

Most likely there is a solution where you don't need that kind of a loop at all.

An index on "almost...

If you refer to SSMS:

RightClick on the DB in ObjectExplorer -> Tasks -> Generate Script

In the Table section you can define to include index def.

Why do you use a c.u.r.s.o.r. in the first place?

Wouldn't the following statement do the same without touching the table once for every row?

UPDATE table2

SET Column1 =t1.Column1,Column2 = t2.column3...

Ok, I stop ranting about poorly designed MRP concepts... Just one last thing: An MRP system (among many other things) should not care about the annual number of stock transactions....

I'm definitely not an MVP, but the most efficient solution from my point of view is to get the people involved who provide the report, ask where they get the...

I think the major issue is the concept in general, not the performance varying between different systems.

8 hrs for an MRP run??? :crying::pinch: Sounds like a SubmittAndPray solution...

The main reason...

You don't really need a c.u.r.s.o.r nor a function.

What you most probably can do: use FOR XML PATH('').

We'd be able to show you how it works but we don't have...

Jeff Moden (11/26/2010)

---

BWAA-HAA!!! Nothing like ratting me out to the Boss! 😛 Now I have to wait for Steve's email to tell me not to hassle the poor...

Steve Jones - SSC Editor (11/26/2010)

---

BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something...

Steve Jones - SSC Editor (11/26/2010)

---

Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past when...

ChrisM@home (11/26/2010)

---

CirquedeSQLeil (11/26/2010)

---

da-zero (11/26/2010)

---

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build...