You won't end up with a collation conflict with an inline query, because they're both being done in the same context.

For example:

;with CTE (ParsedString) as

select substring(@String...

Jeff Moden (7/28/2009)

---

Yeah.... just not one you release to the customer. You only have one chance to make a first impression. Unless the customer is fully aware that...

I'm not saying it's somehow not allowed. I'm not saying it's not supported in any way. I'm saying it's got overkill issues. Express or Workgroup on XP,...

It took a paragraph for you to explain what you were doing in one of the examples. That's what I mean by harder to document. The one with...

sjsubscribe (7/28/2009)

---

You would certainly be considered a disruptive force in an orderly society that protects freedom of speech. Here...

I've never seen that one take any measurable amount of time, so I really can't say why it would in your case.

Can you provide table definitions and an insert statement...

I'm not clear on what you're asking.

Do you need to do something beyond just query that column of data from the table?

I haven't used ntext in SQL 2000 in a while, but I think it has to allocate space for it even if it's null. I could easily be wrong...

You can use xp_cmdshell to query the files in a directory. Would that allow you to do what you want?

I could be mistaken, but I think the XML for the query plan is built in tempdb. So, yeah, it could. Doesn't sound like it should in your...

Jan Van der Eecken (7/28/2009)

---

john.arnott (7/28/2009)

---

Just be careful of starting an internecine battle. There are...

Will this do what you need:

create table #temp1

(

name varchar(10),

ID int

)

insert into #temp1

select 'John',1 union

select 'Jane',1 union

select 'Fred',2...

Have you tried a cross-join?

I've always been on the notification list for my articles. I generally drop the subscription once the topic quiets down and has no activity for a few days, but...

Grant Fritchey (7/28/2009)

---

Luke L (7/28/2009)

---

And of course a ppt preso won't quite cut it. Perhaps...