I'm not sure if that is possible. But, even if it is possible, that sounds like a really bad idea.

Have you investigated using a "listener" app that reads unprocessed rows...

Jeffrey Williams-493691 (5/19/2010)

---

<snip>

However, I would recommend that you get rid of the secondary data file. You can perrform a SHRINKFILE on that with the EMPTYFILE option. Once that...

What's the question?

The Modelers we use?

The One we think is best?

The One that supports the most platforms?

Ones we haven't used?

I wouldn't be too sure that the NOLOCK was not the cause of an issue. It is a fallacy that NOLOCK only gets bad data when there are multiple users...

cfradenburg (5/11/2010)

---

Would it be possible for the following to generate a lower RowID for a higher ID? For example:

RowID ID

1 ...

I don't we have enough information to help you much, but if you are going to store the information so that you ahve a history, I suspect that you'll need...

Jeff Moden (5/10/2010)

---

Lamprey13 (5/10/2010)

---

Jeff Moden (5/8/2010)

---

<snip>

Fifth... [font="Arial Black"]do a SELECT/INTO to build the temp table [/font]instead of building it ahead of time. It will be much faster because it...

Is...

Basically SSIS, but you can downgrade using the Copy Database Wizard http://msdn.microsoft.com/en-us/library/ms188664.aspx

Just for fun I took the two queries from above and added antoher method using the ROW_NUMBER() fucntion along with sample data incase the OP wants to compare them.

DECLARE @SNACK...

I assume that the create script you posted is in error because of a cut-n-paste error?

Just wanted to check that the table is actually being created. 🙂

For fun, here is another way:SELECT T.[Date], T.Value, T.Item, TT.Total

FROM @test-2 AS T

CROSS APPLY (SELECT SUM(Value) AS Total FROM @test-2 WHERE Item = T.Item AND [Date] <= T.[Date]) AS TT

WHERE...

Is it correct to say that the DiagBridgeKey is also in the FactClaims table?

My assumption is that in order to maintain the correct cardinality DiagBridgeKey is the PK on...

Is there a limit on the kind of query you an put in...

No one is really going to be able to answer that for you. People's entire careers are based on how to design and load data warehouses. Sadly, the industry, in...