Friday, October 14, 2011
Wednesday, October 12, 2011
Deleting duplicate rows in SQL Server
WITH TableDup AS
(
SELECT *,
ROW_NUMBER() OVER( ORDER BY IDCol) AS RN_col
FROM dbo.TableSource
)
DELETE FROM TableDup WHERE RN_col > 1;
Tuesday, October 04, 2011
Airline Seating Charts - Best Airplane Seats - SeatGuru
Airline Seating Charts - Best Airplane Seats - SeatGuru
Gives information about seating information, amenities for various airlines and airplanes.
Gives information about seating information, amenities for various airlines and airplanes.
Saturday, October 01, 2011
Subscribe to:
Posts (Atom)