So, let me ask slightly different:

In the previous post we have

13 HRS001 ...

george sibbald (2/6/2010)

---

Mr Flatline, please help us to help you. If this is a homework question remember we are all volunteers here and doing this in our spare time, so...

I'm almost there.

I just can't figure out why ID18 will point to ID17 instead of ID14, even if leafaccntnum=HRS0010001 shows up in row 14 the first time...

Would you please clarify...

I would run the query and insert the results into a temp table.

When sending the mail I'd use "SELECT cols FROM temp table".

sanjeev.k (2/6/2010)

---

Hi lmu92, I have same server and having suppose more than 1000 tables and each table can have millions of records. I've to show these records in my .NET...

Would you confirm that setting parameter 11 is sufficient enough when copying...

Since your question is vague, my answer will be too: it depends.

Usually, the number of tables or number of rows that a reaffected has not really an influence if there...

Are you sure you picked the right forum?

This is a SQL Server forum, not a web site dev forum.

However, you might get lucky and find someone who works in both...

There are several ways:

approach one: optimization of the query itself (especially if it's not set based but so-called RBAR)

approach two: proper index on the tables that support the query

approach three:...

Would you mind sharing what you've tried so far and where you got stuck?

Did you have a look at the articles Jack referred to?

GilaMonster (2/6/2010)

---

One thing to note is that you should be especially careful in setting the parameters that dictate the origin and designation's spacetime co-ordinates (7-14) and the vector of motion...

Seems like I mixed up the links... :blush:

It shows that even here testing is important... 😉

Based on your result set you don't have to do anything because the data are already there (at least when looking at the data you provided).

So we elaborated that you...

Try to use UNION or UNION ALL statement. (For details please see BOL or provide some more details on what you're trying to do).

mbender (2/5/2010)

---

Guess I'm a bit unclear about what your asking, do you want to know what I would expect the results of SELECT * FROM InventoryThatNeedsReorders before or after the...