• merging 2 rows into 1 row

    Hi , i have 2 tables table a m_id name 1 abcd 2 bcde table b m_id id org_name ind_name 1 1192 gold coast 1 1193 fred 2 1196 greg 2 1198 TechTronics i am now generating the report through a sql query whose output shud be id Id Org_name Ind_name 1 1192 or 1193 gold_coast fred 2 1196 or 1198...

    Taffer235 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Multiple instances with SQL Server

    Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

    IMR5 pointsBadges:
  • WSS3/MOSS Search no wildcards?

    When I search in WSS3 or MOSS, I must type a full word and I cannot use wildcards. Examples: "Wilso" will not find "Wilson". "Wilso*" will not find anything. "Wilson" will find all documents with Wilson in the name or in the document body (content search is working). Is there something I haven't...

    FWilson15 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • Linked servers from SQL 2000 to SQL EXPRESS 2005

    I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

    Pdeevi5 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:

    how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

    Roopak055 pointsBadges:
  • Error when updating SQL Server 2000 from SQL Server 2005

    Hi, I am using sqlServer 2005 and sqlServer 2000. When i update on sqlServer2000 from sqlServer2005 then following error was occured. Msg 682, Level 22, State 148, Line 1 Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

    Nileshpatkar825 pointsBadges:
  • System tables in SQL Server 2005

    What is the role of system tables in SQL Server 2005 and how do you update them?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error in SQL Server 2005 with passing a variable

    In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement: define("TF_T_INFO_INSERET", " insert into TFT (WG_ID,task_id,tf_id) SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?

    What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

    Vht5 pointsBadges:
  • SQL Server 2000 script

    Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

    Beginer200825 pointsBadges:
  • Uninstalling a SQL Server service pack

    If we have problems after installing a SQL Server service pack, can we uninstall it with no issues?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server Agent

    What causes an agent not to start? It appears in the services view as starting (instead of Started). WWhen it does start it, you try to do a job and it states that it cannot do so because the agent has not started.

    Bfsteel45 pointsBadges:
  • Transferring SQL 7 DB to SQL 2005 DB

    Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert

    Bertski40 pointsBadges:
  • Error message from SQL Server 2000 Agent after antivirus installation

    SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that it...

    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