Brandie Tarvin (3/19/2009)

---

JacekO (3/19/2009)

---

From my point of view they are not nested but maybe I could call them chained. To explain how I understand the term nested I provided...

You do not have to change the database or column collation in order to use different collations for specific tasks. In fact you can mix collations to match your needs.

If...

Next time you need the ASCII code just run something like this:

SELECT ASCII(code_searched)

Example:

SELECT ASCII('"')

Crap, forgot about the HTML tags eating the code.:angry:

SELECT REPLACE('<MESSAGE type = "XYZ" Content ="XYZ"

Type="Response" Frame="0" Last="1"> ', '"', '')

SELECT REPLACE('<MESSAGE type = "XYZ" Content ="XYZ"

Type="Response" Frame="0" Last="1"> ',...

You do not need to use ASCII code.

This should work.

SELECT REPLACE(' ', '"', '')

In case it does not work for you adn you need the ASCII

SELECT REPLACE(' ...

I think the technology had a great impact on our productivity, no doubt about this. It was a great leap thanks to Google, Internet, WiFi, Remote Access, USB memory, etc.

But...

Steve,

Either I did not understand what your instructions or it still does not work.

That part "(to the left)" is not quite clear to me.

Trying if it works.

(It did not in the preview)

EXAMPLE 2

sales 0

Cast it first, then sum

select sum(CAST [Size] AS DECIMAL(18,0)) from #T where type='d'

select sum(CAST AS DECIMAL(18,0)) from #T where type='L'

That should do it

You can use dedicated SPs to do just the inserts or updates and call them conditionally based on the logic in the main SP. That will make your code more...

Brandie,

At one post I stated that SQL does not nest transactions and I proved my point. I have nothing else to say on this matter. I know and understand how...

Lee,

Overall your code looks fine (assuming I filtered out all your gutting properly)

Few comments:

1. Set BEGIN TRANSACTION as close to the statements that do INSERTS or UPDATES as possible.

2....

Brandie,

No offence but few posts before you gave a definition of nesting. You explained what nesting is. My SQL pseudocode was in a sense a transformation of your pseudocode into...

Brandie,

Let me clarify few things.

1. In one of the post I stated that SQL does not support nested transactions and GSquared tried 😀 to convice me I am wrong. It...

Jeff Moden (3/18/2009)

---

JacekO (3/18/2009)

---

I would keep it simple. Deal with one record at a time. If your Stored Procedure is designed to work fine with one record you can call...