Thanks, Theomed. 🙂

They aren't rules; they are just suggestions. But they are REALLY helpful suggestions.

What you posted, enabled me to produce this...

EdA ROC (7/19/2011)

---

And the plot thickens... :laugh: :crying:

Well, that is exactly what I did!. My notes from reading about indexes are not correct. I thought (wrote...

The reason for the question was that if you are usually looking for all the forms belonging to a particular job, it might be a better idea to have the...

That's fine, Theomed. I hope the CASE example was of help to you.

In the future, you might find it useful to read this article[/url] to see how...

Look at the previous thread he posted at the top, Mike. The way you know is by the sequence of the rowIDs, in his base table.

I'm assuming you are new to SQL, because (1) you have spaces in your column names and (2) you are asking us to list your source data together with totals...

NVARCHAR(1) !!

I love it. I have to change my signature line now.

Seriously, I do want to ask a question, since you said that JobNum/FormNum is unique. ...

And also...

-- To make result = 0 when @test < 0

declare @test int -7

select (ABS(@test)+@test)/2 as result

Use a cte, like so:

;with cte (newvalue) as (select COALESCE etc FROM sometable)

select case when newvalue < 0 then 0 else newvalue end as newvalue from cte

I've glanced at the code and it may be possible to improve it. But it would be really nice to see the schema of the tables involved, including...

The way I read this, guys. He wants a solution that...

kramaswamy (7/18/2011)

---

@jeff,

I understand the relucatance to use loops in order to do set-based processing, but lets say you had a table which had a million records in it, and which...

From the article I deduced it is bad to use select , because you have possible multiple rows. SET doesn't allow for multiple rows, values, if it does then I...

Randy, search SSC for forums and articles with the keywords PIVOT or "cross tab", to see how you can turn rows into side by side columns. ...

Whups, sorry Jason. :blink:

You must have moved when I was absent from the...