• Getting last entries from two different tables

    Hi, I need to get the last entries from two different tables in MSSQL. I can get the last entry for one table by usung the following. SELECT * FROM dbo.Shaft_Scales WHERE dbo.Shaft_Scales.ID = (SELECT max(ID) from dbo.Shaft_Scales ID) The problem is adding another table. Please help

    GPNel200675 pointsBadges:
  • SQL error

    I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

    Nutangujar895 pointsBadges:
  • sql 2008 system tray icon

    how can i add a system tray icon for sql 2008 just like sql 2000?

    Saga10 pointsBadges:
  • Optimizing Query that uses linked tables and bound form w/joins

    I have a bound form whose record source is an Access query.  That Access query involves 3 linked SQL Server tables (one inner join, one left join).  The form takes a while to open. I have run a SQL Profiler and it appears that access is sending two select fields from table without where clauses,...

    Jagoodie60 pointsBadges:
  • Error when insertin.g data into SQL table

                    I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I...

    Obhasha0795 pointsBadges:
  • sql server

    what are the diferent versions of sql server

    Jideesh5 pointsBadges:
  • SQL Server 32 bit, AWE/3GB/PAE

    I have read quite a few articles that recommend turning on /3GB on a server with 32bit SQL server and 32bit Windows 2003 standard where you have between 4GB and 16GB or RAM. Why is /3GB needed? Just so SQL Server can have more VAS, and because VAS is better than AWE mapped memory? This switch...

    Jagoodie60 pointsBadges:
  • Upgrade to IDES CRM 7.0 (ABAP)

    Hi All, My client using sap IDES CRM 5.0 (ABAP) and he wanted me to upgrade to IDES CRM 7.0 (ABAP) . I am new to BASIS, can any one help , which CD's( with the CD numbers and related notes numbers ) to be downloaded from service market place and how to start the upgrade on a stand-alone system in...

    Raja5495 pointsBadges:
  • Windows Server and SQL database upgrade

     We are goging to upgrade server, SQL server databases and domain name, now currently using as following setting 1. Server OS - Windows server 2003 Enterprise Edtion. 2. SQL server 2000 3. domaname xxx1 we are looking and upgrade to new os version, server SQL server and change domain name. 1. ...

    ITKE346,080 pointsBadges:
  • Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

    A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

    ITKE346,080 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy8,323 pointsBadges:
  • Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

    Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport =  'Nov 14 2008 12:00AM' SELECT     LTRIM(RTRIM(T_ASFSTAG0.STANS1)),     LTRIM(RTRIM(T_ASFSTAG0.STHFO1)),...

    LeftForDead20 pointsBadges:
  • Complete System Backup SQL Server

    We are running SQL 2008 on Dell Servers with a wholesale Distribution Package Software by Activant Solutions Called P21 (Prophet 21) Our question is this! WE have a SQL Server and a TS Terminal Server running our Distribution Software and off of this equipment was recommended by the Activant...

    ITKE346,080 pointsBadges:
  • If running two SQL Server db in two VMs, I should purchase two db servers?

    If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

    ITKE346,080 pointsBadges:
  • dbcc checkdb error; object id 0

    Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

    Db23290 pointsBadges:
  • Trigger Use

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes

    I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...

    Cvillavicencio35 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,323 pointsBadges:
  • SQL Database User

    Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

    Rick Martinez585 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