SQL Server 2008 Finding Most Recent Record Only
Hi there I have a databse that logs letter print activity The fields being Letter_Ref Print_date Any time someone prints a particular letter it leaves a date in print ref What i want to do is find the most recent print date for each letter_ref is this possible and if so how

Answer Question   |  July 12, 2010  9:26 AM
SQL Record, SQL Server 2008, SQL Server Query

COPY data between to files with SQL in iSeries
hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don’t have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the [...]

Answer Question   |  January 14, 2009  2:29 PM
iSeries SQL, SQL, SQL Copy Record, SQL Record

I want to retrieve always the first record via sql
I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article

Answer Question   |  November 26, 2008  3:23 PM
SQL, SQL Database, SQL Record