You know, using a staging table isn't necessarily a bad idea with DTS. You can use some optimization (like the "table lock" referenced above) that you couldn't use with...

------------------------------------------

Quote:

Not that the solutions won't work, but I would be careful to implement undocumented features of SQL Server like sp_MSforeachtable in production code.

I would use them only for adminstration...

Hey Mulletboy! There's a couple of options, depending on the cause of your trouble.

Quick and dirty, use the (Nolock) query hint (updated your syntax, too, easier to read this...

I can help with that. On SQL2k run as is (change @DB to @DB if SQL7)

declare @Query varchar(1000),

@FullQuery varchar(8000)

Set@Query = 'Select * From Table1'--Put Query here

Declare @DB Table (Query...

The developer edition is hella cheep now; something like $89 (US) last time I checked.

Lee,

Glad to see you're still kickin'. How'd it go with Isabel? Did the boat make it?

cl

Yeah, I've been playing with this and realized it had nothing to do with setting the variable to itself or the derived table.

Maybe I'm thinking about SQL 7.0, but I...

---------------------------------------

DECLARE @State varchar(225)

SELECT @State = isnull(@State + ',', '') + State

FROM (SELECT DISTINCT State FROM authors) s

SELECT @State

-----------------------------------

Wow...this is really cool...no need for a loop or anything to create a...

Why are there so many complex queries out there to do something really simple?

declare @julian-2 int

select @julian-2 = datepart(dayofyear, '2003-01-01')

Select dateadd(dd, @julian-2, '12-31-2002'), @julian-2

Obviously there would have to...

Hans,

Still...nice trick! And if you know there are no deletions occuring on the table then this will work.

This is what I use:

SELECT top 1 *

FROM <table name>

order by <identity...

I usually use a DTS package to move any db objects (and small amounts of data) from one server to another. The task to use is called "Copy SQL...

Steve,

Word.

cl

Nah...never met him. Wish I could, though; he has an old reputation as a bit of a "anti-hero" with the SF establishment. He moved on pretty quickly, but...

Yeah, he's a character alright! Seems like an incredibly inteligent guy, and he doesn't give a crap for what people think about him.

Never realized until today quite how prolific...

OK, never mind. Found the book online (took a lot of searching, for some reason).

It's called "Dangerous Visions" (1967) and I highly recommend it for SF and/or trip (ta)...