Line Delimiter, Line Ending in different system

unix = lines end with LF = char(10)
dos = lines end with CR LF = char(13)
mac = lines end with CR = char(13)

DELETE Duplicate, SQL, Mark Duplicate

WITH CTE AS
(
SELECT MyStatus,ROW_NUMBER() OVER
(PARTITION BY [EmployeeID]
Order BY [EmployeeID] )
AS RowNumber,
[EmployeeID]
FROM [dbo].MYTABLE tbl )
--DELETE FROM CTE Where RowNumber > 1
--SELECT * FROM CTE Where RowNumber > 1
update CTE set eligstatus='DP'
where RowNumber > 1
GO

Where to Buy a Home ??

http://realestate.yahoo.com/promo/where-to-buy-a-home-for-less-than-800-a-month

5 Common Misdiagnoses - Importent!!

http://health.yahoo.net/rodale/MH/5-common-misdiagnoses-for-men

good article ;)