quote:

---

Originally posted by itmasterw

Hi,
I have this code that tell me is a coumn changed. Tyhan someone helped me with here. Thank you And it works great. The only thing is that it gives the first column the name = "ColumnAChangeYesNo"
but the other coumns does not have a name. How can I gieve each column a name here? (I would like something like colA, colB, colC).
Thank you

ALTER PROCEDURE dbo.ComparProc
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

Select
ColumnAChangeYesNo =
Case
WHEN a.text1 <> b.text1 THEN 'Yes'
ELSE 'No'
END,
<second col name here>=Case
WHEN a.text2 <> b.text2 THEN 'Yes'
ELSE 'No'
END,
<third col name here>=Case
WHEN a.text3 <> b.text3 THEN 'Yes'
ELSE 'No'
END
FROM tbl_reportA a
INNER JOIN tbl_reportB b
on a.text1 = b.text1
END


ITM

---

quote:

---

The AS clause is the syntax defined in the ISO standard for assigning a name to a result set column. This is the preferred syntax to use in Microsoft SQL Server.

---

quote:

---

Originally posted by Lamprey

For what it is worth, you should be using the AS Clause to name/rename columns. Per BOL:

quote:

---

The AS clause is the syntax defined in the ISO standard for assigning a name to a result set column. This is the preferred syntax to use in Microsoft SQL Server.

---

---