Oops.

Got it. Add this to the inner join:

FOR XML PATH (''), type

so it looks like this:

SELECT DISTINCT LocalID as "@ID"

, (SELECT ItemUrl

FROM foo X

WHERE f.LocalID=x.LocalID

ORDER BY x.photoseq

FOR XML PATH(''),...

Just so I had some data to mess with, I modified your query to use something form AdventureWorks:

SELECT A.ProductId "@ID"

,a.Name "Col1"

, (SELECT x.StandardCost

FROM [Production].[ProductCostHistory] X

WHERE A.ProductId=X.[ProductID]

ORDER BY X.StartDate

FOR XML PATH('')

)...

Until we get the 2008 MERGE statement, you need to do three passes through the data, joining on the incoming data such that you do a batch of updates where...

Luke L (10/19/2007)

---

Luke L (10/19/2007)

---

Well let's see, I started off with 2.5 years attempting a Sound Engineering Degree (The goal was to go work for Skywalker sound out on the...

I still don't understand what you mean by tasks & processes. What those are and what you're attempting to compare between the database and the front-end?

Do you mean the queries...

I'm one of those flaky individuals who kind of backed into this gig. I did four years in the Navy. I was effectively an inheritor of Robert Fulton, working on...

You could try creating a table valued user defined function that uses dynamic sql to run a query against the table you have and then generate a select statement. The...

There are TONS of ways. Here's one simple one:

SELECT * FROM [INFORMATION_SCHEMA].[TABLES]

WHERE TABLE_SCHEMA = 'dbo'

I'm sorry, I don't understand what you're asking.

Do you mean, where are the stored procedures? Depending on the app, there may not be any, but if there are, they're part...

Unless you put a lock on the table as suggested in the previous post, yeah, the second query will try to delete what the first query was doing.

You may want...

Derek Karpinski (10/18/2007)

---

Nolock - depends on your db. But can be useful, if you are careful to only use it on SELECts.

Where you don't need absolute acuracy. For...

Sounds reasonable. I guess I'm going to have to get off my dead behind & get my MCDBA.

Seriously though, it doesn't sound unreasonable. You just need to get the infrastructure...

Exactly.

Another option might be to keep them in the call app and pass them in as either a delimited list or XML list and then either turn the delimited list...

Well, it depends. Most of the time, yes, but watch for Table Spool operators in the query plan as a way to spot interim tables being built. You'll definitely see...

If you read Itzik Ben-Gan's book on SQL Querying, he lumps CTE's and derived tables together because they are so similar in behavior (as you're seeing in the execution plans...