ColdCoffee (2/16/2012)

---

How about this?

1. Create a new database in another server with only one table that matches your source table

2. BCP out data from your source table to a file

3....

Can you help us understand your intent? It looks like you're trying to overload a single column to mean foreign and scholarship. Why would you do that when...

SQLKnowItAll (2/16/2012)

---

jake.mayher (2/16/2012)

---

I agree with Jeff, ETL is in no way specific to the dimensional data warehouse. I define ETL as any process which takes data from one source into...

Ah, thanks J.

Lost, just an FYI, your code doesn't run well. You've mixed and matched #table and hard tables in there. No worries, I realize you're new, we...

In full recovery mode minimal logging is out.

You'll have to include backups into your process. Do a delete, backup the log. Perform an insert, backup the log. ...

Hey Lost. Easiest ways are either using a Tally Table if you had one handy, or a quick and dirty Row_Number() function.

Is it possible you can setup that sample...

Jeff Moden (2/13/2012)

---

Actually, this is all very easy using BULK INSERT which now allows you to do like we used to do in BCP. Sequester errors in a file...

Avoiding the overseas sub-topic...

I'm there now, I'm on a project that hit an oil slick and is at warp 12. Most of it's due to network kablewies during long...

Brandie Tarvin (2/16/2012)

---

Evil Kraig F (2/15/2012)

---

Brandie Tarvin (2/15/2012)

---

bitbucket-25253 (2/15/2012)

---

Now, now be honest is it the chocolate or the...

Another +1 for a good question. I got it right by sheer luck. I ignored the trailing semicolon bit earlier, mostly because I always forget them anyway... *blush*.

Seriously...

Was the sp_executeSQL statement parameterized? It might be caching a bad plan the same way bad parameter sniffs affect queries. This would be my most likely assumption. ...

SQLKnowItAll (2/15/2012)

---

I would actually structure the application to call separate stored procedures based on the parameters provided. This way you don't have this messy code; i.e. GetResumesByName, GetResumesByNameAndNumber, GetResumesByCity.

More...

Using Dynamic SQL is an excellent choice for removing the pain point from catchall search queries like this one.

For one of the most effective discussions on it, review this link...

What is the issue? EDIT: Before you ask, no, I didn't run it to see. I...

The ForEach loop can handle looping...