• How to write Bcp command to insert data in to a table

    Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #--indicates to be inserted in next row : --indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use BCP. Can any one let me know how...

    GIG240 pointsBadges:
  • SQL Cursor to use or not to use

    Hi, I've been told to never use cursor in SQL, because of possibility of memory leak, etc. But I have no idea of how to implement my script without them. My script doesn't execute anything on the database, it simply use cursor to create another TSQL script that does the execution. EG. open cursor...

    Db23290 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I hav been trying to learn sql 2005 from lyk a month or two and i think i have done a good job. Now i was about to try some security stuff in it but i saw that sql 2008 is in market. Can any body suggest me that what is the difference between the two and can I swich to sql 2008? what ever i learned...

    JrSoftwareDeveloper5 pointsBadges:
  • Query performance and tuning

    Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

    Mingley5 pointsBadges:
  • How to create User Xml tags Based on SQL data

    I have a sql table which contains the details of controls used in the application. Now I want to create a xml file for the data in the same table based on the ControlType in the table. I need to get different tags and subtags for controls based on the control type. How do i go about it?

    Eclat5 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • SQL Column Headings

    When I run an SQL statement the column headings I see are the field names. When any of the other members of our team run the same statement they get the field descriptions as column headings. I have compared user profiles and there are no differences. Is there some other place that this setting is...

    deniseg35 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Update a field in one table after the change on a field in another table using a trigger in SQL

    I have a WODet table and after the field "Complete" is changed to "True" I need to update my SODet table field "UD3" to "True" using a trigger in SQL where dbo.SalesOrderDetails.SalesOrderDetailID = dbo.WorkOrderDetails.SalesOrderDetailID Thank you in advance

    Tanjaatbrenlo40 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 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:
  • SQL statement exceeding 2000 characters in Oracle Graphics Builder

    In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.

    44063860 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • SQL error. There is already an object named ‘InitCap2′ in the database.

    I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, Procedure...

    Mmoreno5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • run oracle 9i with Windows Server 2003 Domain Controller

    sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like SQL....

    Swapnesh15 pointsBadges:
  • SQL Error

    SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

    Odunsi5 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