Does this have anything to do with your tableA-tableB thing? If *all* emp records in...

Greg Snidow (11/9/2007)

---

This should do what you want

UPDATE tableA

...

This should do what you want

UPDATE tableA

...

Greetings. I had a similar situation recently where I was having mail sent through a trigger. I posted here, and the consensus was that sending mail within a...

Christine M (11/8/2007)

---

These are what worked. Thanks!

SELECT IsNull(q1.ProdGroup, q2.ProdGroup) as NameofProdGroup,

ProdCodePROD,

ProdCodeANL

FROM (

select ProdGroup,

count(ProdCode) as ProdCodePROD

from smcscalc..ERVProdGrp_ProdCode

where ProcessDate <'12/20/07'

group by ProdGroup

) As q1

FULL OUTER JOIN (

select ProdGroup,

count(ProdCode) as ProdCodeANL

from smcscalcanalysis..ERVProdGrp_ProdCode

where...

Greg Snidow (11/8/2007)

---

Greg Snidow (11/8/2007)

---

So are you saying that in Word you replace spaces with '& nbsp' or just '&'? I think I will try it with a view...

Greg Snidow (11/8/2007)

---

So are you saying that in Word you replace spaces with '& nbsp' or just '&'? I think I will try it with a view that would...

Jeff Moden (11/7/2007)

---

First, the riddle of the easy copy and paste you did... it wasn't in a code block, it was in the normal text of the message... but to...

Greg Snidow (11/7/2007)

---

Wait a minute...I could have sworn I copied and pasted an example of yours right in to QA and it retained its format. Maybe I'm mistaken. ...

Jeff Moden (11/7/2007)

---

Problem is, if you copy from the code block to query analyzer, it really kills the format... you'll need to copy to Word, replace ^l with ^p, recopy,...

Just curious, but what is the difference between <> and NOT IN?

I sure as heck can not figure out how to do that. When...

Not sure exatly what you are looking for, but you can try this to start

SELECT

c.ProdGroup,

c.CalcCountProdCode,

...

Ok, I just realized you wanted a column to show the sum of the students marks in all subjects, not the sum of all marks of all students in each...

Something like this ought to work for you.

IF OBJECT_ID('TempDB..#Marks','u') IS NOT NULL

DROP TABLE #Marks

GO

CREATE TABLE #Marks

(

Stu_ID INT,

Sub_Name VARCHAR(30),

Marks INT

)

INSERT INTO #Marks

SELECT '1','MTH','90' UNION ALL

SELECT...