Use the '//' that you want to find all occurrences. Something like p.query_plan.nodes('//sp:RelOp/sp:OutputList/sp:ColumnReference')

Drew

Remember that CASE is a "function"...

It means pretty much what it says. You don't have a table named or aliased "table3" in your query. You can't reference a column in a table that...

XML is case-sensitive. That appears to include the .nodes() function.

Drew

Not necessarily. On my sample data, using IN outperforms using NOT IN by a significant margin. I assume that this will mainly be...

New does not necessarily mean better. (In fact with MS it often means buggy.) Jeff Moden shows in his article

Cross Tabs and Pivots, Part 1 – Converting...

memymasta (11/23/2011)

---

The logics is we need to loop through every user to send email to each one. Also we need to loop through items so we can add them to...

Justification is a presentation issue and should be handled by the presentation layer not in T-SQL.

Drew

100.00 * Sum(Sale)/NULLIF(Sum(Quote), 0)

This makes sure that you are not performing integer division and also produces a null result when Sum(Quote) is zero.

Drew

Once you define an alias on the table any...

The first step is to choose the correct tool for the job. In this case, the correct tool is reporting software, such as SSRS, not T-SQL. This kind...

In order for the recursive CTEs to work, it actually needs to be a directed acyclic graph, i.e., it can't have...

Excel is a spreadsheet program, not a database program. It makes a terrible database program.

Excel is a spreadsheet program, not a user interface design program. It makes a...

Remember what i said about relative paths? All of your paths are absolute. (They start with a '/'.) You need to use relative paths. The '.',...

Yes, it's a T-SQL question, but you posted in both the T-SQL (SS2K5) and the T-SQL (SS2K8) forums. I assume you know whether your server is SQL 2005 or...