prtk.raval (6/5/2013)

---

this is working 100% , when we handle only specific table names for source and detination and we can harcode everything.

but the merge statment which I am using ,...

Lowell (6/5/2013)

---

so much of it depends on how it was presented, also;

As a veteran of more than a couple of posts here,

How well the question is phrased directly...

I think I read it after you edited it. 😉

At any rate it would be very helpful if in the future you could post ddl and sample data. I put...

--edit--

nvm I misread the question. I will toss together something that can do this shortly.

floresg2 (6/5/2013)

---

Sean Lange (6/5/2013)

---

I would suggest not bothering with Fizz Buzz. That one is old and overused. Anybody who is preparing for interviews runs across that one and has a...

Have you considered parameter sniffing? What happens if you add WITH RECOMPILE to the proc?

branovuk (6/5/2013)

---

Hello,

I have next task:

From one database, 3 tables (each 3 fields are chosen) to insert in another database's fields from 4 tables.

First source database is simple, will create a...

chaijxiong (6/5/2013)

---

Assume that there are a lot of people (e.g. 1,000+) are inserting records simultaneously into the database, will using SCOPE_IDENTITY (or any identity) right after the insertion return the...

I would suggest not bothering with Fizz Buzz. That one is old and overused. Anybody who is preparing for interviews runs across that one and has a canned response. Change...

prtk.raval (6/5/2013)

---

Please find an attachement , which indicates what I need for the solution and how my solution should look like.

The problem is when I use that merge statment which...

SQL_Surfer (6/5/2013)

---

I have two backup files that need to be restored to the same database. First file is already restored. How do I append (restore) the second file

to the same...

Funny...I got the exact verbiage from the same place. 😀

Yes that would be the best approach. The problem with...

Jack Corbett (6/5/2013)

---

SQLRNNR (6/5/2013)

---

Sean Lange (6/5/2013)

---

Jeff Moden (6/4/2013)

---

Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of the building as...

How many threads are you going to start on the same topic? In all of them you continue to not provide the details needed to help yet people keep providing...