You are welcome!

po 35213 (2/27/2013)

---

A simple regular expression can do the job fine. I had to delete all records from my words table which begun with a capital letter. Here...

Welcome to the forum!

If you really want to receive help immediately (or at least close to this) here, I would suggest you to follow forum...

Yeap, it's another good...

SQLKnitter (2/28/2013)

---

Others have responded with good solutions. I have used both with good results, but want to point out that Crystal Reports can do this tidily. It has more built...

I guess you will need something more like that:

SELECT AntiBiotic

,COUNT(CASE City WHEN 'Boston' THEN 1 ELSE NULL END) ...

I guess, if the rewriting your stored proc to work on a required set is not an option, use advise about converting proc into TVF and use it with CROSS...

I'm not exactly sure what you are looking to do, it would...

To convert varchar to nvarchar you can use CAST or CONVERT function.

However you don't need to convert values inserted into nvarchar column, as they already will be converted on insert.

If...

I would call it just 1 tier application which consists of multiple tiers. 😎

This question about SQL Server is a bit irrelevant.

polkadot (2/25/2013)

---

SQL_Enthusiast,

I double and triple checked the book and the WHILE query in my original post is a facsimile.

The where clause condition is slightly different, it excludes o1.supervisor<>o1.employee. ...

Debbie Edwards (2/25/2013)

---

Eugene Elutin (2/25/2013)

---

That is exactly the thing which makes me...

That is exactly the thing which makes me suspicious that the OP...

There are few things here.

1. Your code example has a small visible bug:

You cannot insert 'TOTAL_Exclamation_Mark' value into your #SSC table as it's longer than maximum allowed by your...

No, this will not be exactly enough to make it robust...

If...