1
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • I am new to JavaScript. How can this be done properly?

    function setColors(e){ e.style.backgroundColor='red'; e.style.borderColor='green'; e.style.color='blue'; } function getColors{ var E=new Array( document.getElementById('a'), document.getElementById('b'), document.getElementById('c') ); for(i=0;i<=E.length;i++) setColors(E[i]); }

    Tronyc5 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • Help finding duplicate info in Excel in different columns

    Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 or Store2,...

    Hmstacco20 pointsBadges:
  • Oracle Applications view functions mapping

    hi, I have a query regarding Oracle Applications (OA) and I hope you will be able to assist me. I am looking for a list of OA functions which are VIEW functions, according to the hard-coded definition of Oracle. In other words, I am looking for a list of FORM FUNCTIONS that allow users only to view...

    Orit15 pointsBadges:
  • Explaining certain functions in SQL

    What do the MOD function and the ROUND function do in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
1

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.

Thanks! We'll email you when relevant content is added and updated.

Following