aliasing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

aliasing

Author

Topic

WJHamel
Aged Yak Warrior

651 Posts

Posted - 2012-05-10 : 13:12:14

what the !@#!!! am i doing wrong in aliasing this??:


Update dbo.arr_afss t1  set DATE_ISSUED = [Issue Date] from dbo.ALLWARRANTSERRORCHECK t2 where t1.ARRESTNO=t2.arrestno

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-05-10 : 13:21:06

[code]
Update
t1
set
DATE_ISSUED = [Issue Date]
from
dbo.arr_afss t1
INNER JOIN
dbo.ALLWARRANTSERRORCHECK t2
ON
t1.ARRESTNO=t2.arrestno[/code]

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

WJHamel
Aged Yak Warrior

651 Posts

Posted - 2012-05-10 : 13:22:40

ugh, aargh, and ack. thank you.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-05-10 : 13:26:24

No sweat. Also, i would use the alias for the updating data also ( t2.[Issue Date])

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources