A picture is worth 1000 words....Thanks!

Steve Jones - Editor (11/6/2007)

---

Matt, I actually like the detach idea. That might make you think of it a bit more.

The idea wasn't so much to focus on deleting a...

In case you happened to have a 2005 Server available - here's the "new" version.

insert Random_region_lookup_table(generation_number,entry_key,,place_key)

select gens.n Generation,regions.n region,Row_number() OVER (Partition by m.n order by newid()) ranks from mynumbers gens,...

....then dynamic SQL is your friend in this case...

Jeff -

Do you have a good example of that? I'd be curious to see one. (the outer join getting messed up due to position of the AND)

Personally I would have felt comfortable with ditching the delete from within SQL Server and just keep the Detach option, "forcing" you to earn your delete by having to delete...

:Whistling:oh.. I don't know....never done THAT before....:blush:

Of course - I could understand why some are surprised that it's gone....Might I draw your attention to this section of the BOL for SQL Server 7.0?

In earlier versions of...

Sergiy -

On the INSERT part... you SURE you want to NOT include the keycol?

I'm assuming that's a cut/paste error?

Happycat -

My exposure to it (even within 2005) is that the index doesn't help with queries using like as a "contain", e.g. with leading and ending wildcards. ...

The *= is a leftover from a long-gone ANSI standard, which is no longer current (ANSI-89). As of SQL 7.0 that syntax was declared deprecated, but wasn't removed from...

Sorry to say. but if there is a foreign key in place, TRUNCATE TABLE will not work. It's one of the stated limitations of the TRUNCATE TABLE syntax. ...

I didn't explain that very well. I was thinking of an entirely separate table, probably holding just one row, called "ImportStatus" (or anything descriptive to you).

For the purposes of...

You may have more luck having a OS process (like a .CMD file or a .NET console application) check for these files and fire the SSIS package off one http://FTP...

This might not be palatable, but here's a thought. Add a step at the beginning of your import process that updates a "site status" table from "online" to "offline"....