Thank you.

Thanks for the response. I don't know what the valid codes are as they can be added dynamically, so I'm not sure how well an IN will work. Let me...

I am trying to get the SUM of a field for all records with a code between two values, e.g. 600 and 699. Those values however can be alphanumberic, e.g....

Thanks for the help.

sturner (7/2/2010)

---

something like this perhaps?

select sum(case when field1 = 'A' then 1 else 0 end) as SUMA,

sum(case when field1 = 'B' then 1 else 0 end) as SUMB,

sum(case when field1...

Nevermind, I figured it out, I can just subquery in the select statement and not try to use a join.

Various SQL statements.

Found it, never mind.

Microsoft SQL Server Database Publishing Wizard 1.1

It appears that you were checking before on both the employee and call both needed to have the same Classification or Division

in order to be selected. From...

Was thinking something like this would work?

update SECO_GLTRANS set Processed_Flag = (case WHEN Processed_Flag 'Y' THEN 'Y' ELSE 'N' END) WHERE Posting_Date = '20090329'

Mark (11/26/2008)

---

SELECT * FROM mytable

WHERE POLE_ID NOT IN

(SELECT DISTINCT POLE_ID FROM mytable L

WHERE (L.DATE1 IS NULL OR L.DATE2 IS NOT NULL OR L.DIVISION <> 'E') AND L.IGNORE =...

It has Named Pipes and TCP/IP Protocols enabled.

I wasn't using a connect string (per say, I'm sure there is one in the background somewhere), I...

Ok I changed the Client from TCP/IP to Named Pipes and it resolved the issue. Anybody better at SQL than I am tell me why that would resolve it? Thanks!

Thank you