Nothing to be upset about. Your explanation helps as well.

Thank you for taking the time add...

Arrogance, it seems, returned it has. Oh well, much hope I have no longer.

I have to concur with Bob, but I would still like to know if you still think that cursors are the only way to solve problems or if we have...

Okay, so the concatenation of ', ' + Col1 results in the loss of the column name and the FOR XML PATH ('') replaces the . I think...

It's the FOR XML PATH part that I am not really sure about myself. That's why I was asking for some help here. I'd like to understand it...

Okay, I can use stuff((select ', ' + cola from dbo.table1 t1 for xml path ('')), 1, 2, '') but I sure can't explain the how's and why's. Anyone...

I am going to have to defer your questions to someone who has a better knowledge of FOR XML PATH. I picked up this little trick here on SSC...

A Little Help Please (3/19/2009)

---

Thansk, you guys have been very helpful.

the problem is, the source table sysjobhsitory has the run_date set as INT.

In my SSIS I converted it to a...

Derek Dongray (3/19/2009)

---

Bob Hovious (3/19/2009)

---

I presume it was the first statement.

What I know of chaos theory leads me to disbelieve the concept of "Temporal Inertia", although conversely it leads me...

Yes I am. Try taking the single quotes...

Yes, there are issues with the query itself, but what did the question ask? How do you ensure you get the top 25 in sales. The only answer...

Christopher Stobbs (3/19/2009)

---

If in your table you declare rundate as a datetime and just insert into to from sysjobhsitory run date the conversation should happen automatically.

here is an example of...

LGibson69 (3/19/2009)

---

I expected to get no records because the transaction was still open but, when I ran it on SQL 2008 I got an error message saying "Msg 208, Level...

Also, FOR EACH ROW is used in Oracle, not in Microsoft SQL Server.

I have to agree with Chris above.