you're welcome, good luck!

Interesting proposition! Posting this for discussion's sake, use at your own risk!

for each destination table TABLE_NAME, have a matching table TABLE_NAME_IMPORT with the same named columns.

IF OBJECT_ID('tempdb..#COLUMNS_2_CHECK') is not null

BEGIN

DROP...

rollercoaster43 (4/9/2013)

---

Hi All,

I have created an stored procedure which uses thebelow select statement :

select getdate(),'Old or No Backup At All For the database ' + s.dbname + ' no backup...

Eric M Russell (4/8/2013)

---

patrickmcginnis59 10839 (4/8/2013)

---

Eric M Russell (4/5/2013)

---

TravisDBA (4/5/2013)

---

Eric M Russell (4/5/2013)So, an a-hole boss will inevitably surround himself with either a-hole subordinates or mediocre supplicants. Meanwhile the most...

Amy.G (4/8/2013)

---

I can't believe this. My query went from nearly 10 minutes to 2 seconds. I had this idea that the data had to be summed before joining. The dangers...

Amy.G (4/8/2013)

---

OK, thank you for the link on ancient ceramic toilets 😛 But anyway, you are asking why don't I just put it in a regular table? Correct? The...

tamil.selvanmca (4/8/2013)

---

Sir,

I am working in Medical college campus.They have 5 server in our campus.

I have done a Port for...

"Bog Standard" http://en.wiktionary.org/wiki/bog_standard

(idiomatic) Especially plain, ordinary, or...

Just curious, what's the drawback of using a bog standard join using tables? (posting a wild guess at such a query :w00t:)

SELECT grads.student_ID, grads.Lname, WAGES.SumWage, WAGES.SumHours

FROM GRADS

JOIN

(

SELECT year, quarter, ssn,...

opc.three (4/8/2013)

---

patrickmcginnis59 10839 (4/8/2013)

---

mister.magoo (4/8/2013)

---

patrickmcginnis59 10839 (4/8/2013)

---

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

Shifting gears a bit, you've been stressing the auditing aspect of things. What type of system auditing do you currently...

mister.magoo (4/8/2013)

---

patrickmcginnis59 10839 (4/8/2013)

---

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

Shifting gears a bit, you've been stressing the auditing aspect of things. What type of system auditing do you currently have setup on...

Eric M Russell (4/5/2013)

---

TravisDBA (4/5/2013)

---

Eric M Russell (4/5/2013)So, an a-hole boss will inevitably surround himself with either a-hole subordinates or mediocre supplicants. Meanwhile the most talented people will simply walk...

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

I do...

Nice one Lynn, beats my multiple max operators hands down :w00t:

LOL queue the experts to post a more elegant solution!

Anyways, I'm just throwing this out there for discussion's sake, make sure you test any solution you develop for suitability for...