• 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:
  • Optimizing a SQL Server stored procedure

    I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • I want to load XML to a table in SQL Server 2005

    i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

    Mitha10 pointsBadges:
  • SQL Server transactions in ASP code

    Can we create sql server transactions in asp, if so how can we manage transactions in asp. Please suggest me, how to do it.

    Vini Chandamama100 pointsBadges:
  • Spreadsheets

    Does Word allow you to perform calculations in spreadsheets?

    Jaimo325 pointsBadges:
  • Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • TVCPL Table

    I get this error when trying to create a return delivery in SAP. Copying is not possible because an entry is missing in Table TVCPL: ZRMC

    boocrews5 pointsBadges:
  • I need to reboot my OS on my Windows XP Home edition desktop

    Every time I turn my old Dell Dimensions desktop on, it reads writes/read error at checkpoint [PnP1]. I need a free copy of reboot disk for Windows XP Home Edition. Does anyone have one? Please help.

    nowl0075 pointsBadges:
  • Error message 503 outlook

    I periodically get error message as above when I use my contacts list or sometimes when i respond to e-mail. Error message 503 Valid RCPT command must preceed data

    shpdoc5 pointsBadges:
  • Why did my screen suddenly go dim and how can I fix it?

    While using Scribus self-publishing website my laptop screen went quite dim.  Restarting did nothing.  Windows 7 system

    TomBanfield5 pointsBadges:
  • What is calibration?

    What is calibration in Nokia Siemens?

    basu5 pointsBadges:
  • Drawing with hyperlinks

    I have a floor plan diagram that I would like to set up so when I hover over a location it will hyperlink to another sheet in the workbook.  Does anyone know how to do this?

    petercj5 pointsBadges:
  • Microsoft Dynamic question

    I need some help (I've tried to answer this question so many times but can't). A device connected across the imput of an S-R flip-flop to insure complementary inputs is? Expand terminals are used with logic gates to increase the? If the signal input to a sense amplifier exceeds the reference...

    gates5 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Install SQL Server Client Components on Windows XP

    I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then...

    SteveInfoTool5 pointsBadges:
  • Differences between SQL Server 2005 Standard Edition and Enterprise Edition?

    What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check Max Worker Threads in SQL Server 2005

    We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

    BrentSheets6,875 pointsBadges:
  • Performance issues with a large table in SQL Server 2005

    I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup...

    Thecoolestguy5 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • Backing up a SQL Server 2000 database through VB.NET 2005

    How might I backup a SQL Server 2000 database through VB.NET 2005?

    SQL Server Ask the Experts2,585 pointsBadges:

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