Looks like you want to do an INNER JOIN between the two tables. That's about as much as I can tell from your psuedo code.

Can't tell if you just...

I received your email, but I'm at a lost as to what you are trying to accomplish as well. You really need to show us what you are trying...

MrBaseball34 (12/12/2008)

---

I need to also get a 0 count when ther is no resources for the selected date.

How would I do that?

SELECT ResourceID, COUNT(ScheduleId) AS Count

FROM ptSchedule

WHERE (Status <> 5)...

You can't change the sort order in the Object Explorer, but while the column folder in Object Explorer is highlighted, you can sort the column names in the Object Explore...

I don't see the IT field going away. I think it's here to stay. What we do in the field, howver, can very easily change.

This is what I...

This is what the code should look like:

DECLARE @batchsize INTEGER,

@rowcount INTEGER;

SET @batchsize = 100000;

SET @rowcount = @batchsize;

WHILE @rowcount = @batchsize

BEGIN

...

Jack Corbett (12/12/2008)

---

I like tabs and I use 6 and I like to set it to 6 even if I change set it to use spaces. One of those...

jcrawf02 (12/12/2008)

---

jcrawf02 (12/12/2008)

---

Lynn Pettis (12/12/2008)

---

So, having noticed items 2 through 4, where do you fall?? Also, I may be an old fart, but I can keep up with high...

You can disable the database trigger with the following sql statement (change the name of the trigger, as this is the name of the DDL trigger in my version of...

The column parent_class_desc will say DATABASE for a DDL trigger.

You can find your Database Triggers under progammability in the object explorer.

Start in your current database with the following query and then move to the master database. You may find that there is a DDL trigger that is firing when...

Steve Jones - Editor (12/12/2008)

---

Tab settings can be inconsistent, and so if you try to line things up, or open someone else's code, 2 tab stops could result in things...

Steve Jones - Editor (12/12/2008)

---

Why did this thread start?

I feel old until I read some of these posts.

Been driving on four wheels for 26 years, 25 cars in that time,...

jcrawf02 (12/12/2008)

---

lol y'all are nuts. I haven't checked in on this thread for a while, last time it was actually related (more or less) to the title, now I come...