Ninja's_RGR'us (3/15/2011)

---

What about doing insert into where not exists?

That query should fly, even if there's 1 M rows in the big table.

Also I think his question was referring to the...

A simple "Union" is likely to degrade performance because of the sort and dedupe action in it. If you mean "union all", then that probably won't degrade performance.

I would...

Don't Case statements need an "End" to terminate them?

Since it's just his account, and only when RD into the server, I suspect a permissions or account configuration issue. Maybe something in the HKEY_CURRENT_USER portion of the registry.

I'm...

I've used two parameters for that. One multi-select, one text field.

Skip xp_dirtree and use a CLR function for this. VB.NET or C#.NET can easily handle file system tasks, including account and password control.

Are you trying to export from two different tables to two different flat files? Or from two tables to one flat file? Or are you trying to get...

I guess it depends on what you want to do.

Personally, for most file system access, these days I use CLR for that.

It looks to me like either the servername is wrong, or that you possibly have either a network or DNS issue.

I suspect that what you've got is an infinite self-join in the way you've written the CTE. I'd need to see the definition of the tables and the data...

I'd have to see the code before I could even begin to help on this. Can you post the table definition ("create script") and the code for the procedure?

Brandie Tarvin (3/11/2011)

---

Now that's an interesting solution I never would have thought of.

But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the periods)....

To hide that error, you need to either add Try Catch blocks to the T-SQL code doing the insert, or you need to have the front end application capture the...

If you look at the execution plan, it will tell you what it's doing with it. You can also check "set statistics io on" and see data movement in...

I, for one, welcome our new reptilian overlords ....

(Now I can't remember where...