This returns the rows in the order you want according to your sample data.

drop table #mytable

create table #mytable

(

ID int,

Value varchar(20)

)

INSERT INTO #mytable

(ID,...

In your sample data you don't have any NULL values. They are all empty strings.

In addition to what Luis posted you need to check out this article. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

It explains how to avoid some major performance issues with search type queries.

Like this?

select Date, Item, Sales, 'WEN01' as SomeColumn

from SomeTable

octavuslimited (7/22/2013)

---

Hi Sean, you make a good point (though I do detect a little sarcasm in your tone perhaps?!). Actually, the server, user and password are all encrypted (RSA...

I would drop the column with clear text. You have two copies of this information now, 1 is encrypted and the other is not. If the only column you have...

Why do you need to have both encrypted and clear text columns? This defeats the whole point of column level encryption. You haven't protected the sensitive information at all this...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

The biggest issue you have here is that your trigger is flawed. It will only handle single row inserts. Also, from the code you posted I don't see any reason...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

Here is a good article that explains this common misconception and provides an easy to follow example of ordering with no order by clause going wrong.

http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

The data is now encrypted at...

Well you know have kind of shifted gears. At first you wanted to protect the data. That is a good idea with any sensitive information. It sounds like you have...

Sarah Johnston (7/19/2013)

---

The value is actually null, not a string. The 3 queries suggested are what I ran to get the counts in my first post. Run from the 2005...

As I said before, you cannot use the same name declared multiple times...