Please create the test table I used, with the insert I used, in the database you are testing, and run your copy of the code on that. See if...

One statement is that win_id is the relationship between the two, but that column does not appear in either of those table definitions. Is it supposed to be in...

Yeah, but did you see the reply to that?

What's up with the grapes table that only has a priority column? What does that have to do with anything at...

You're welcome.

Karma (1/21/2009)

---

What would be the point of cyphering messages that very clever enemies couldn't break? You'd end up not knowing what they thought you thought they were thinking...

Lord Vetinari...

You need to have a Group By clause on that query. What column of which table is the date supposed to come from?

Can you post the execution plans of the fast queries and the execution plan of the slow query? The code for both of them would be helpful, too.

You'd have a table of Mines or Sources. Since some are "mines" and some are "workings", I'd go with Sources and have a type column.

create table dbo.Sources (

SourceID int...

The only thing I can think of on that one is that perhaps the Where clause is causing a problem.

Also, I don't recommend using both Group By and Distinct in...

First, why use a trigger instead of an Identity column?

Second, you assign a value to a variable by:

declare @MyVar datatype

select @MyVar = column

from table

Third, you need to look at the...

The type of join is going to be based on what end result you want. Do you just want results that are in both tables? Then use "Inner...

After you redefined it as ragged right, did you refresh the columns?

I'll give my usual recommendations:

Spend a lot of time on sites like this one, read and post both questions and answers.

Find a book that communicates well to you.

On the book...

majorbloodnock (1/21/2009)

---

Well, if President Obama's phone is anything like any of the Windows Mobile devices I've seen, I'd say it'll be very secure indeed. I've not seen too many of...

Speed on something like that will depend a lot on how you query it and how much data you are querying. Can you post the code you have so...