The system view sys.triggers will work as well.

Ed Wagner (4/7/2016)

---

Brandie Tarvin (4/7/2016)

---

SQLRNNR (4/7/2016)

---

Brandie Tarvin (4/7/2016)

---

NEVERMIND.

Stupid power users changing table...

Rod at work (4/7/2016)

---

Peter Schott (4/6/2016)

---

Rod, I did that very early on when I was just starting out. I ended up moving without any idea if I'd find a job...

Luis Cazares (4/7/2016)

---

Lynn Pettis (4/7/2016)

---

This:

INSERT into [JP_CDM].[case]

SELECT

*

--ucn,

--lcn,

--court_id,

--case_initiation_date,

--case_restriction_flag,

--county,

--date_disposed,

--recurrent_flag,

--intestate_testate_flag,

--case_referred_to_mediation_flag,

--contested_flag,

--jury_trial_flag,

--outstanding_warsumcap_flag,

--pro_se_flag,

--record_source,

--record_state,

--create_user,

--create_date,

--maint_user,

--maint_date

FROM

#case_tmpTable;

select * from #case_tmpTable

Is not going to work as there are not an equal number of...

Rod at work (4/7/2016)

---

Peter Schott (4/6/2016)

---

Rod, I did that very early on when I was just starting out. I ended up moving without any idea if I'd find a job...

Andy Warren (4/7/2016)

---

Lynn, it by Plugable, see http://www.amazon.com/Plugable-UD-3900-Universal-Docking-Ethernet/dp/B00ECDM78E/ref=sr_1_1?ie=UTF8&qid=1460034655&sr=8-1&keywords=plugable+usb+3.0+dock. About $90. I'm using their two port USB switch in front of it, kinda KVM'ish.

Seems to work fine. Only issue I...

BL0B_EATER (4/7/2016)

---

I Would not move, I have turned down much bigger salaries where if accepted I would've sacrificed my time with my daughters. When push came to shove I didn't...

jpgillum (4/7/2016)

---

Here is the solution:

drop table #case_tmpTable

SELECT * INTO #case_tmpTable FROM [JP_CDM].[case]

where 1 = 2

ALTER Table #case_tmpTable

DROP COLUMN case_id

------------------------------------------------------

The code above creates the temp table structure based on the...

Jeff Moden (4/6/2016)

---

jpgillum (4/6/2016)

---

------------------------------------------------------

[font="Arial Black"]Do the required processing and load the #case_tmpTable

[/font]Then do the insert into the target table without specifying the column names.

I can now use the Select *...

Andy Warren (4/6/2016)

---

Lynn, I just moved to 27" monitors at home. Monoprice has had them for $250 (2560x1440). Seems solid so far. I use a USB dock so that I...

Sean Lange (4/6/2016)

---

SQLRNNR (4/6/2016)

---

jasona.work (4/6/2016)

---

SQLBill (4/6/2016)

---

Sean Lange (4/5/2016)

---

Luis Cazares (4/5/2016)

---

I...

When you someone points you to an excellent solution, why would you reinvent the wheel using a much more inefficient method and then try to defend it?

djj (4/6/2016)

---

Had to look up pepperdew, sounds good. Breakfast time here, blueberry muffin...

Sean Redmond (4/5/2016)

---

Hi Lynn,

Working from home is hard. I do it now and then when a child has an appointment at the doctor's and when my wife is not at...

You sure about this" If getdate() returns 2016-04-06 and your valid froms include 2014-01-01, 2015-01-01,...