Simon Facer (7/2/2008)

---

Why do you say that? I'm not necessarily an advocate...

Steve Jones - Editor (7/2/2008)

---

It's hard to QA the questions sometimes. It requires a huge amount of knowledge of SQL Server and you'd have to spend an inordinate amount of...

Congrats. Well deserved. 🙂

John Rowan (7/2/2008)

---

Yes, this is what I thought also, but the OP had not mentioned using SQL...

Odd. I don't get that in mine. The plan just gets rid of the other two columns, but is otherwise identical.

Jeff Moden (7/2/2008)

---

Wow...

I'm with Gus, but let me go one step further. With 5000 procedures (I assume that's like saying "a bazillion"), and all those ugly WHERE clauses, etc,...

I have to admit, these days, I generally use the GUI to build maintenance plans and schedule them. Easier than writing my own cursors and all that.

declare DatabasesCur cursor local fast_forward

for

select name

from sys.databases

... set up the cursor, open it, assign the name to a variable

While @@Fetch_Status = 0

Begin

select @sql = 'Use ' + @DBName...

I'm talking about something like this:

eclare @CurrentDt smalldatetime

declare @CurrentDtStr varchar(8)

set @CurrentDt = getdate()

set @CurrentDtStr = CONVERT(VARCHAR,@CurrentDt,112)

WHILE NOT EXISTS

(SELECT *

FROM DB2_PROD_DCDB.DCDB.APP.NIAD_ETL_STATUS

WHERE CONVERT(VARCHAR,etl_dt,112) = @CurrentDtStr)

AND datepart(hour, getdate()) < 23

BEGIN

WAITFOR DELAY...

Generally, for that kind of thing, I use a cursor to step through the databases and run a dynamic SQL command on each one. It's the only place I...

Inserting it into a staging table means you don't have to mess around with making the clustered index match the order in the import file. You can use a...

You have a proc/script in your trace that doesn't select/update/insert/delete anything in any tables.

I think that's just a display issue in the plan. I get the same thing with both versions of your query.

You have my sympathy. As expected, a procedural programmer with no clue how relational databases work.

It can be done as a series of joins, which will be faster, but...

Good that it works.

I was only looking for table definition data if the query didn't work.