Good point Kraig. Just use his query with my order by clause and you should be there. 😉

You can add a case statement as a where clause like this:

select Short_Name from t_One where short_name like 'val%'

union

select short_Name from t_One where short_name like '%val%'

order by case when short_name...

Look at MAX and Group By

Yes

James Goodwin (10/5/2011)

---

Access Memo fields are equivalent to SQL nText data type. If I were doing this manually, I would bring it in to an nText and then copy...

pwalter83 (10/5/2011)

---

Hi,

I have a requirement to update the values in a table thru SSIS, however, there is a primary key restriction. The table has a combination of 3 columns as...

Yes that is true. Was just being precise about your comment that it would find all records with a single space. 🙂

Take a look at the undocumented stored procedure. sp_msforeachdb

This will do what you want without the need for dynamic sql that you will encounter in this cursor.

Paul Bradshaw (10/5/2011)

---

You can very easily generate SQL to do the updates, to save you a lot of typing. You can whip up something like this very quickly:

SELECT 'UPDATE...

John Mitchell-245523 (10/5/2011)

---

I don't. This question is couched in...

ramadesai108 (10/4/2011)

---

Thanks all for your time. I have now resolved the issue but just facing one more issue of case when in where. Hopefully I will resolve it soon. Again,...

ramadesai108 (10/4/2011)

---

Sean,

Can you please take a look at my SP, the challenge is right at (@StartYear IS NULL AND @EndYear IS NULL)) where I need to...

Jeff Moden (10/4/2011)

---

Sean Lange (10/4/2011)

---

I think that may be further proof that few people has utilized this...nobody want to speak on a topic that they don't know about. I am...

I could say "Yes". It doesn't really matter...

drew.allen (10/4/2011)

---

Sean Lange (10/4/2011)

---

Yes like mentioned you cannot perform multiple aggregations on a single column. You can however split this into two pieces in a subquery and perform your calculation...