Are you saying that if, for instance, column c is null for a particular row, don't return that row.

select

*

from

dbo.MyTable

where

...

I'm sorry, but I don't see any errors in your post. What errors are you receiving?

darryl (12/12/2008)

---

Thanks for the pointer. I will try to do it better.

First of all, the only code I tried was to select the records. If figured the first...

Read the article that both Seth and I have in our signature block. It will walk you through the steps you need to do to get the best help...

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.