Lot's of good questions Roy.

As one of the people that does have certs, I like them. I know that I meet the minimum standards for being a MCDBA / MCIPT...

Lowell,

This works for me...

declare @input varchar(max)

--set @input = char(13) + char(10) + '

set @input = '

--for users who are too lazy to type "SELECT * FROM" ...

Okay, try N <= len(@input). It doesn't fix your issue, but it does now work on the whole string.

Lowell,

If you substitute this for the end of your code, you will see that @input does not end with a CRLF... just a CR. Maybe this is it?

...

Exactly what I was thinking. (also didn't like 4 updates going on...)

The "correct" answer doesn't have a column in the where clause... how can that be SARGable?

I've modified what you...

It's looking good to...

callum.bundy (2/25/2010)

---

Hello,

After having a discussion with someone regarding how SSMS organises databases in the list (i.e. alphabetically) I was wondering if anyone had ever created an addon for it that...

Daniel Hallam (2/25/2010)

---

We here have a team mascot of Fozzie Bear from the Muppets. He sits on the desk of whoever messed up last. We've even attached a bicycle horn...

Asha.Richardson-1129890 (2/25/2010)

---

to Wayne:

Basically, your change worked as long as I put in a few column names, but when i just ran your query, I got this message:

Msg 421, Level 16,...

Okay, I made it through the day and finally learned something new! Good...

Asha.Richardson-1129890 (2/25/2010)

---

I have two query's here. One is a select statement to verify the # of rows I am going to update, the ohter is the actual update statement....

This would be appreciated.

Okay, understood.

I want to loop thru payment...

Yes... and all of your sample data is for 1 account, and 1 fund, on one date. How do we tell that the $75 payment goes to the first pledge,...