Lynn Pettis (1/4/2016)

---

SQLBill (1/4/2016)

---

I stayed up way longer than normal during the holiday break, but I forced myself to get in the bed (and sleep) on my 'normal' time so...

I stayed up way longer than normal during the holiday break, but I forced myself to get in the bed (and sleep) on my 'normal' time so I'd be back...

LuisC and mw112009,

Thanks for pointing that out. I've never seen or used that before and it will come in handy at work.

It's a good day! I learned something new.

-SQLBill

How did you set the PK to allow duplicates? The purpose of a PK is to not allow duplicates and the only way I'm aware of to allow duplicates...

Late to the conversation, but here's my input...

I have worked in a career where lives could be on the line (not daily, but frequently enough).

You have to make sure the...

I haven't seen it yet, but my daughter and son-in-law have and they said "If it wasn't a Star Wars movie, it would be a 'wait for the DVD' movie."...

Now this is why I like these forums.....

Someone posts code that works but might not be the best way (me) and then others follow-up with their suggestions. No one...

I didn't see jshahan's post....that one seems more 'elegant'.

-SQLBill

I came up with this that seems to work:

DECLARE @ProductIDTable TABLE

(ProductID INT)

INSERT INTO @ProductIDTable (ProductID)

SELECT DISTINCT ProductID FROM Table1

UNION

SELECT DISTINCT ProductID FROM Table2

UNION

SELECT DISTINCT ProductID FROM...

You don't give sample data for us to use, so this is what I came up with...you may have to tweak it to work with your data.

**Ignore this code...I must...

Run this:

Select TCH.Cas_ID

,TCCL.Cl_ID, TCC.Cntac_DT

INTO #tmpTable

From dbo.TCas_History TCH

Inner Join dbo.TCas_Client TCCL

On TCH.Cas_ID = TCCL.Cas_ID

Left Join dbo.TCas_Cntac TCC

On...

Your joins pull 'everything' based on the joins, but then the where clause 'kicks in' and eliminates some of the date because it doesn't meet the where condition.

Basically, combine everything...

The only thing I notice different between the two scripts is the check for date/time value in the second script. So that is where I would focus my troubleshooting....

Where I work, we deal with health care stuff (HIPAA). I don't get a laptop, but others do. Everything is encrypted including email. Lose the laptop and ...

This really wasn't an issue until AlwaysOn. The SID was server-specific which rarely was...