• Retrieving values from a table in SQL

    I have values stored in a table in SQL this order: -99.4%, 99.5%, -99.6%, -99.7%, 99.8%, 99.9% I'd like to retrieve them in this order: -99.4%, -99.6%, -99.7%, 99.5%, 99.8%, 99.9% The ORDER BY clause does not do so. Is there another clause I could use?

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL Query- how to explode XML fragment stored as NText into table?

    I'm using a commercial storefront software that offers "extension data" fields as NText to store custom data. I am storing an xml fragment that looks like this: <priceSplit xmlns="http://tempuri.org/priceSplit.xsd"> <split> <type>Credit Processing Fee</type>...

    Lambrite5 pointsBadges:
  • email query recordset

    "I have a query (emailnotifytest) based on 2 tables . One table (shipmentdata) filters on new records. the other table (contact) filters which contains the email address filters whether the address is not null. The tables are joined by the companyname. the code below works as far as sending the...

    Roundy5 pointsBadges:
  • Concatenate

    I have a value in a column that I need combined on 1 line. I need a new row when the Id in the table changes. For example Column A Column B 1 Boyd 1 Honaker 2 Steel I need the row to be 1 Boyd, Honaker 2 Steel I can get the name column to concatenate but I get one large line. I can't figure out the...

    Musiclover5 pointsBadges:
  • EMC Clariion CX700 Problems – Data Sector Invalidated

    Hello, I have two EMC Clariion CX700's (which, for convenience we call CX700-1 and CX700-2) and one recently added CX3-40 in my SAN environment using fiber-switch fabric. Over the weekend, I experienced a hardware failure on SPA on CX700-1. After having it replaced by my vendor's technician and...

    UniCal0 pointsBadges:
  • Equallogic

    Hi, Just looking for people's experiences of using Equallogic SAN attached storage. Specifically - Performance - Interoperability - Cost - Competition - Management software Thanks in advance Noz

    Nozmeister00 pointsBadges:
  • MS Terminal Services Client Control (redist) not available when XP Pro Installed with SP3

    I recently loaded XP Pro on new machines using media with SP3. When I finished all MS updates, I attempted to access Remote Web Workplace (RWW) on our SBS 2003 (connect to client machines and/or server). I got a warning about my IE setting blocking the install of an Activex but IE settings are not...

    CASLIT75 pointsBadges:
  • Generating valid XML with a Lotus Notes View

    I am using XML generated by a Lotus Notes view in an AJAX application. The difficulty occurs when the value in one of the fields in one of the records in the view contained an ampersand. The resulting XML was then invalid. There should be a function @HTMLEncode which would work like the @URLEncode...

    McCulloch5 pointsBadges:
  • Not Return Any Record if Value Exists

    If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

    Rjwilcox45 pointsBadges:
  • SQL Text Match on Character Stream (wildcards)

    I need to match a text field on zero or more characters. If available, the 'or more' characters need to be in a specific sequence. The % wildcard doesn't quite cut it. For instance, I need to match the name with 'm', 'ma' or 'mar' (but no other character combinations). Is this possible?

    Ohreallyus5 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Questions about a SQL database with hourly transaction log backups

    We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file...

    SQL Server Ask the Experts2,585 pointsBadges:

    Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...

    Chukbillo20 pointsBadges:
  • enterprise service bus

    What are the advantages and disadvantages of the enterprise service bus

    Peter7245 pointsBadges:
  • create .csv file from table

    how to create a .csv file which will contain data in 2 or more tables

    Cpp5 pointsBadges:
  • date functions using Oracle

    Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is in...

    Maha15 pointsBadges:
  • to write code

    i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it...

    Daudkhan5 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • Can I do create dynamic table while bulk insert ?

    Hi, I am Software Engineer, I am using SQL-SERVER, I have a issue with it. I want to write a query to dynamically create a table when using BULK Insert. No of Column is dependent upon no of fields available in first row. Assume that in each row no of column is same.Column name can be any string,...

    ARUNKUMAR1125 pointsBadges:
  • AR server

    we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

    Jiji5 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.

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