Hello,

Thanks for the response. However, I still have two questions:

1. Why is the X necessary after the DELETE key word? Wouldn't DELETE FROM demodelete x WHERE x.somenum = 1; work?...

Hello Lutz,

I was talking about the SELECT statement in this thread posted yesterday at 4:12:48 PM:

SELECT export_id,stuff(( SELECT ','

...

No, it isn't. The problem is that it isn't returned as a string correctly.

Regards,

Gabor

Hello,

I have played quite a bit with this and found that this is not exactly working properly for some reason.

Please look at the 5th insert statement in my post yesterday...

Hello Guys,

Thanks a lot for the explanations and ideas. This is a lot for me to digest, so please bare with me for a day (or two). I am brand...

Unfortunately no.

First, because it returns the error message which this whole thread is about.

Second, because, as you pointed out, this is a work in progress and...

Hm. No. But it does sound logical...:blush:

Thanks.

Hello Lutz,

Thanks, yes, I would definitely like to learn about more efficient ways of achieving what you assumed correctly I want to do. So below is the requested info. BTW,...

Hello,

Thanks for the extra set of eyes! Good catch!

However:

1. It did compile despite that typo (which is strange...)

2. When I corrected it, it did not compile (a CONVERT was required).

3....

Hello Lowell,

Thanks for the help.

No, it does not. It returns

Msg 208, Level 16, State 1, Line 1

Invalid object name...

GSquared (6/17/2008)

---

On the parentheses thing, do you mean:

insert into t (col1, col2, col3)

select col1, col2, col3

from t

If that's what you mean by putting the columns in parentheses, yes, this is...

Thanks for the response, Kyle.

Yes, in fact my statement had columns initially, I just put the * there to be more concise.

Since then I realized that if I put the...

Jack Corbett (6/11/2008)

---

READ COMMITTED is the default Isolation Level in SQL Server. This is why a select will not finish until any exclusive locks are released.

For example in my...

Thanks!

Gabor

Thanks, that's quite clear now!

Gabor