• Update from another table and multiple criteria

    update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID) The above does not work with the error Msg 4104, Level 16, State 1, Line 4 The multi-part identifier...

    MyDanes35 pointsBadges:
  • SQL installation

    What is an Instance Name? What is an Instance ID?

    BlessedOne10 pointsBadges:
  • Backup and Restore different SQL Server 2012 Editions

    Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.

    TLMercer45 pointsBadges:
  • Forget SQL Server Password?

    Last week, I have forgotten SQL Server password and I am not able to get any solution from anywhere. It’s very important for me. Please give me such software that helps me to reset or recover SQL password. Thanks in advance!

    ClientsQuery10 pointsBadges:
  • VarChar to Numeric in SSRS

    I am trying to convert from a varchar to numeric format using the "Expression" in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to "Sum" the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The...

    tonyhid10 pointsBadges:
  • Flowchart and algorithm

    How can I find a flow chart and algorithm of a program that finds the minimum of three values?

    melkamu15 pointsBadges:
  • SQL server native webservices and PHP

    Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure...

    Claubolson35 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

    We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • MSDTC promoting a transaction only in some environments

    We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn't been enabled...

    Bee1075 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • How to insert Hex values through SQL/400

    Hi, I'm creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can be possible to insert...

    color10 pointsBadges:
  • SQL update a column to remove a certain character

    I have a table (book) where there is a column that contains number in some rows and numbers with an addition *infront. I want to be able to perform some calculation with the table but the '*' is preventing me from doing this. So how do I update or alter the table so that I can remove the * and keep...

    Lazy16755 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Need to create a bootable server 2003 CD

    Hello, I have a burned copy of Server 2003 Enterprise edition that a friend gave to me. I'd like to install it on my test server, but am unable to because the CD is not bootable. I have tried booting the server with a 98SE floppy boot disk but am unable to run setup through DOS. I currently have a...

    Kfettig5 pointsBadges:
  • Install SQL server client tools

    With client utilities like query browser, or query analyzer...how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we...

    Krblr200720 pointsBadges:
  • Receiving undeliverable email we did not send

    Hi everyone, One of our users keeps getting undeliverable email messages. It looks like someone out there is sending mail and making it look like it is coming from him. Is there anyway to stop this? We are running Exchange 2007. I don't think it is relaying or a virus. It does this even when his PC...

    Fuddstud0 pointsBadges:
  • Creating second instance on SQL Server 2008 cluster

    Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk...

    PowerEdge5 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 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