• Importing Excel data into SQL Server and filtering columns of Excel data in SQL

    I'm trying to import Excel sheet's data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?

    dammu5 pointsBadges:
  • Unidirectional replication in SQL Server 2008

    Can transactional replication be bidirectional?

    Dougm10 pointsBadges:
  • Linked server SQL select into

    I'm trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I run this...

    ToddN200011,820 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN200011,820 pointsBadges:
  • Creating service accounts in Windows 7 home edition

    In Mike Hotek's book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.

    kerrycorr5 pointsBadges:
  • Best practice when using a shared table across multiple databases

    Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn't find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don't want to have this table duplicated in each project's...

    skoub5 pointsBadges:
  • Open IT Forum: IT’s role in customer service

    One of ITKnowledgeExchange's bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We'll take horror stories as well! Help a fellow IT...

    MelanieYarbrough6,345 pointsBadges:
  • Which config file does MySQL use?

    Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message:...

    jailall101735 pointsBadges:
  • Getting 2008 voting data inside Spatial

    When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

    lloydia5 pointsBadges:
  • SQL Studio 2005 expired but it is not evaluation copy?

    What happened? SQL Studio 2005 says evaluation period has expired even though I have a licensed copy of SQL Server 2005 installed. Please help.

    Nan57225 pointsBadges:
  • Constant variable in SQL cursor

    select  gthamcode as hamcode, gtnumber as item, 'G' from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, 'M' from testlib/hammodel where (modndcnum between 08000000000 and 08999999999) This works with interactive SQL...

    lalaabs5 pointsBadges:
  • SAN to SAN hardware level replicaiton to replicate MSSQL 2008 R2 databases

    If SAN to SAN hardware level replication solution is implemented, how can we utilize this solution to transfer MSSQL 2008 R2 databases' MDF and LDF files.

    MSSQLDBA5 pointsBadges:
  • Assign a serial number for each group

    I want to assign a serial number for the below data using the Access query or by using SQL for Access DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211 I want the output like as below: S.noDateItems...

    Tharanya5 pointsBadges:
  • Data migration from AS/400 DB2 to SQL Server

    Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?

    Explorer1910240 pointsBadges:
  • Recursive SQL error

    For the life of me I can not see what my problem is. Any help would be appreciated. *************** Beginning of data **************************************** WITH RPL (LEVEL, PINBR, CINBR, QTYPR) AS (SELECT 1, ROOT.PINBR, ROOT.CINBR, ROOT.QTYPR FROM ITSTRU ROOT WHERE ROOT.PINBR = '8B714-0005651'...

    Timothy0125 pointsBadges:
  • Stored procedures

    What is meant by stored procedures? What is purpose of them and where can we use this stored procedure? Can any one provide the information regarding this? Thanks in advance.

    ravula700 pointsBadges:
  • How to open SQL 2005 after installation

    How do I use SQL 2005 after installation?

    lathalakshmichitra5 pointsBadges:
  • Validate SQL and display the output

    I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether it is valid or not....

    RamvishakRamesh2,505 pointsBadges:
  • Run Oracle Procedure in SSRS dataset

    Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

    redusn19505 pointsBadges:
  • High usage of SQL Server

    The SQL Server usage becomes high....How do I reduce the usage of SQL Server? The system performance becomes slow.

    senmalar210 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