Do you like puzzles?

declare @in varchar(50)

declare @out varchar(50)

set @in = '[p]a]a]s]s][p'

select @in as [IN],

(

select r+''

from

(

...

...

Don't need the DECODE function, it was confusing to me, found use CASE WHEN more readable if verbose. Packages, just reminds me of ADA and after working with SQL...

Lynn Pettis (5/15/2012)

---

Eugene Elutin (5/15/2012)

---

Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources....

Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and logging resources. Because table variables have...

Lynn Pettis (5/15/2012)

---

I am going to just say we are going to have to agree to disagree. I am not going to say that the Primary Key should most...

Lynn Pettis (5/15/2012)

---

Eugene Elutin (5/15/2012)

---

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a...

kwe477 (5/15/2012)

---

Excerpt from below link:

...

Dynamic queries:

are nothing more than ad-hoc queries built using a dynamic string. Dynamic queries are considered ad-hoc queries by the optimizer because they are not...

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a better choice, and should...

jonas.kasper (5/15/2012)

---

Yes I do...

I am creating a job that will send emails every morning showing different data that has occured during the last day. Some of the data that is...

Or, yeah!:cool:

To OP:

Are you sure you need a cursor for what you're doing?

ISNULL(tb_2.column_2, 'Undefined')

reidres (5/15/2012)

---

Thank you, but no.

While the output of your proc is correct, I am literally interested in either a process that matches my topic title or a definitive...

It's not applicable for dense_rank, where order is enforced. After second...

If nothing has changed, it would continue to work.

So, something has changed! (It doesn't work now - it's a change!)

Is this only bit doesn't work? Any other parts of code...

I would think that ADO has a problem with oppening the connection to SQL server as per your "Friday's" environment.

DNS changed?