Please don't call us "blokes". This is not a chat room for kids but a professional forum.

Regarding the issue you're struggling with:

I recommend to call a stored procedure with the...

That's the trace approach Gail mentioned in her first reply (option 2). Make sure you're taking care of...

Nice solution, MM!

Would it be possible to set the flag to either "true" or "false" depending on the value of frac or would this require a second update?

jonegerton (7/22/2011)

---

That's a nice idea and I'll have a think about it, however my real world example has these problem nodes buried quite deeply in a large xml document stored...

Straight off the web:

The SQL Server Native Client...

...contains the SQL Server ODBC driver and the SQL Server OLE DB...

What do you define as a "SQL Server client"?

If you want to access data on a server, you could either use SSMS or any type of ODBC connect (e.g. ACCESS,...

I'm not sure if there's an easy way to do it using XML DML, but here's a slightly different approach: shred the xml and rebuild it

; WITH cte as

(

SELECT ...

As soon as you perform a SELECT * and you're looking for an index seek, you could either make Date the clustered index or add another index with all columns...

Are you looking for something along those lines?

SELECT

CustomerName AS '@name',

(

SELECT DiscountType AS 'discount/@name',

DiscountRate AS 'discount'

FROM @Customer c2 WHERE c1.CustomerName=c2.CustomerName

FOR XML PATH(''), type

)

FROM ...

I don't think we really disagree here, Elliott.

However, I would not compare a decision between SQL and .NET with a decision between Oracle and SQL Server.

To summarize it: "It depends."...

Or, to rephrase my previous post and put it a litlle more toward your original question:

have a look at the SQL Server related patches and what the fixes are about...

I'm not sure if it's a "short sighted" position:

I'll have to deal with arguments like the number of viruses available to attack the systems and the risk/additional effort involved with...

If you assign an alias like "ALE" to sep5.V_ALERTS you'll actually have to use it in your join syntax.

Replace sep5.V_ALERTS with ALE

or do you, by any chance, have table names with a period being part of the table name? :sick:

Meaning sep5.V_ALERTS is not referring to table (view?) V_ALERTS in schema sep5...

it might be this section of the code:

left outer join sep5.V_SEM_COMPUTER s4 on sep5.V_ALERTS.COMPUTER_IDX = s4.V_SEM_COMPUTER.COMPUTER_ID

There is an alias on "s4" on...