1
  • 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

    Davewaltonuk20 pointsBadges:
  • SQL Server Help

    Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial --returns 'ASEEADL1234567' based on...

    Cdizl25 pointsBadges:
  • SQLCMD does not create a log file

    I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

    Harv200250 pointsBadges:
  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 pointsBadges:
  • Making two records into one

    I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail AS...

    Fscopel15 pointsBadges:
  • How do I limit my SQL output to one record per student?

    Current resuls: Student ID: Guardian 2 Joe 2 Mary 3 Goldie 4 JIm Needed results: Student ID: Guardian 2 Joe 3 Goldie 4 Jim

    Richieg5 pointsBadges:
  • 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 correspond...

    BUG68235 pointsBadges:
  • 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

    Fra90820 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following