You could use a For Each Next loop, and have a recordset that lists the files you want to import.

Then for the other part, have a second step that does...

It can. It depends on log growth events locking things up, which will happen in Full, and can be avoided in Simple if the load is done in small...

Looks to me like he's asking you to do some documentation. At a guess, some of it goes into tables, some of it into documents, and some of it...

GilaMonster (12/7/2009)

CirquedeSQLeil (12/7/2009)

GilaMonster (12/7/2009)

Oh man. Bob, I LOVE your reply to that thread. What I was thinking, but too...

How long will depend on the hardware, but a 700 Gig database will take a while to check. Hours doesn't sound outrageous to me.

Won't matter. It's a connection property, not an object property.

Since you'll mainly be calling UDFs from within procs, if you set nocount on in the proc, that'll handle it.

To the left of the box where you type your post, there is a list of the most common tags. If you click on the one for code="sql", it...

GilaMonster (12/7/2009)

Yup.

Well, it's listed on my profile, so...

Okay, you lost me now. The tables exist in an Oracle database, but you're running the query in an SQL Server database?

"Case" doesn't work that way in T-SQL. Try this:

SELECT *

FROM Table1 T1

JOIN Table2 T2

ON T1.var1 = T2.var1

AND

(@i = 0 AND T1.var2 = T2.var2

or

@i = 1 AND T1.var3 = T2.var3)

cb10.(whatever) references a schema, "cb10", and a table or view, "tidcafac" in this case. Does that object exist in the database where you're running this?

A server-side trace or Profiler is the best way to do that.

What you want is the Batch Complete event, and you want the Text column.

For one thing, it looks like you're missing spaces in a few spots. That's quite possibly the error.

How about laying out the code so it can be read?

For inline table-value UDFs, no (because you can't). For the rest, yes.

Edit: Nope. I was wrong. Can't set it.

She just took exception to being called "antiquated". You must have a death-wish! 😀