LOL. Forget about efficiency I want this in a single query no matter how slow!!! 😀

Pretty sparse on the details here. I can think of several ways of doing but it all depends on exactly what you are trying to do. As Anthony said UNION...

Something like this should get you there.

select * from @t c

WHERE c.name LIKE '%[0-9]%'

order by cast(replace(c.name, 'count_', '') as int)

That is because you are ordering by characters. The only way you will be able to get your results in the order you want is to order by something else,...

I would tend to lean on the side of preferring tabs to spaces. I have worked in some environments where tabs would retain spaces like you mention but everybody had...

Spam reported on posts above.

That is really the definition of how foreign keys work. The value in the foreign key column MUST exist in the original table. As Lowell said you either need the...

Hi and welcome to SSC. Please take a look at the first link in my signature for best practices on posting questions. It would make this lot easier to answer...

duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1268345-364-1.aspx

Lynn Pettis (3/16/2012)

---

er.sivaganesh (3/16/2012)

---

thanks for every one who joined in this discussion i just solved this problem by creating cusor in...

patrickmcginnis59 (3/16/2012)

---

Sean Lange (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

jeff.mason (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

Sean Lange (3/16/2012)

---

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is...

patrickmcginnis59 (3/16/2012)

---

jeff.mason (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

Sean Lange (3/16/2012)

---

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is testing syntax on...

Lynn Pettis (3/16/2012)

---

Sean Lange (3/16/2012)

---

I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not...

I would recommend skipping the local installation and just the online version. There are frequent updates to the online version, your local installed version will not have those updates.

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is testing syntax on a construct that we strive...