User Profile

Collapse

Profile Sidebar

Collapse
srinivasang87
srinivasang87
Joined: Apr 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • srinivasang87
    started a topic Avoiding UNIONS
    in SQL Server

    Avoiding UNIONS

    Hi,
    I have a query with three select statements joined using two UNION's.
    All three queries differ ONLY in the where condition.

    It goes something like this:
    Code:
    select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
where
    Band = "A"
union
select
    Emp_No,
    Emp_Name,
    Salary
from
    Employee
    ...
    See more | Go to post
    • srinivasang87
      replied to Preserving the Character set inside text area
      in Javascript
      I thought on the same lines. But javascript doesnt do anything special here!
      These are the things I tried..

      1. s=escape('& ');
      document.writel n("escaped string : "+s);

      t=unescape('&am p;');
      document.writel n("unescaped string : "+t);

      Both returned '&'

      2. <xmp>&amp;</xmp> OR <pre>&amp;</pre>...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...