• select only duplicate employee numbers

    How does one select only duplicate employee numbers to be printed? Sounds simple?

    Moonquest15 pointsBadges:
  • Server 2003, NTBackup Utility, Shadowcopy Service and Network Drives.

    Good afternoon! I have an interesting scenario I'm trying to resolve here. Namely, I wish to execute a centralized backup of Outlook PST files for my users across my building. The problem is that most users do not log off, or shut down Outlook. This is not a situation that I am able to remedy, as...

    Lonewolfbw525 pointsBadges:
  • Is there a server running on localhost: 3306?

    Has anyone seen this error before? We've got a Windows 2003 Standard Server running MySql 5.x.x, with ColdFusion MX 7.x.x. Everytime we try to add a new MySql DSN Connection we get this error: Connection verification failed for data source: cudefault java.sql.SQLException: Communication failure...

    Ozzyit25 pointsBadges:
  • Running different versions of MySql on same machine?

    Is it possible to run different versions of MySql on the same server machine?

    Ozzyit25 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • Create Information_Schema view

    Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views? Thanks for the help... --Jeff Moden

    Jeff Moden30 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

    I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

    Narayananv5 pointsBadges:
  • Daily trigger in SQL

    I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

    Barend IT15 pointsBadges:
  • how to compare 2 dates == x day and delete the file

    hi, do any one know how to compare the 2 dates.comparing today's and the file created date using mysql and c# here is my program but i am stuck string ConnectionString = "server=localhost;user id=name;password;persist security info=True;database=name of database;"; using (MySqlConnection conn = new...

    Blue50 pointsBadges:
  • Access Database, columns, calculatons

    Hello to everyone. I really need an answer to this question. anyone that can help, it is extremely appreciated. I have a database that has a number column, which relates to a text colum. the text colum has two differnt types of information in it. i need to add the number column, but only for...

    Mstweety10 pointsBadges:
  • MS Access-Query

    I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

    FranktheMan15 pointsBadges:
  • how do i display session id on the web

    hi, I am doing a login page with mysql and asp.net/c#. I would like the program to run in the following sequence. 1. the user login 2. the login page will search through mysql database, 3. when it is Authenticate, it will allow the user to access. my concern now is how to you use the session id to...

    Blue50 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • execution plan is same even though it takes 10 times longer to run

    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

    Abbi20 pointsBadges:
  • Using Access Data Bases on My Web Site

    I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By...

    Strategist15 pointsBadges:
  • ms sql case statement

    I have written a case statement in MS SQL that is returning a single phone number for a single id. This is valid as the database contains multiple phone numbers attached to the same id number, with differentiation based on phone type. Once I have found the prefered phone number, I do not want to...

    Espqueen5 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Wireless solution for Condo project?

    I am on the HOA board for our condo complex. We ordered a qwest business internet package and we are trying to find a good cost effective method to distribute the internet to everybody via wifi. The complex is 4 stories high, and has about 50 units total, with a big shared open lobby in the middle....

    Dorkisfoo5 pointsBadges:
  • Question on LoadAll Subfile.

    Hi, How to load more than 9999 records in the case of loadall subfile??? And i don't want delete previously loaded records. Thanks, Rama Krishna

    0 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