SQL Mad Rafi (9/23/2014)

---

Jack Corbett (9/23/2014)

---

I'm assuming that you mean when you pass NULL to an insert/update statement?

There are a couple of things I think would work, 1...

That's going to be a problem since PARSENAME is a function. is it really such a broad exclusion, because that's...

Waiver - at the present time I happen to work for an org that sells Cyber liability insurance. In my previous work I did a lot similar items to...

Can you provide the context where you plan to use that formula?

Bringing out the golden hammer to categorically stamp out any exceptions to "no functions, etc" tends to leave...

Have you tried going for a fancier pattern? If all you want is to find the pattern, no sense in parsing the string

I kind of think this is what you...

Grant Fritchey (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Grant Fritchey (9/15/2014)

---

I'd think the easiest way to do this would be to cheat. Rename it. Then name it back.

But, that could cause errors in the...

Have you considered persisting the "split" values?

With the queries you're running against substrings of a column - I really doubt that any form of indexing will help. ...

Matt Miller (#4) (9/15/2014)

---

the #deleted marker is there only as a reminder from Access' ADO or ODBC connector that you attempted to insert something. It's flagged that way to...

the #deleted marker is there only as a reminder from Access' ADO or ODBC connector that you attempted to insert something. It's flagged that way to denote that something...

You're not accounting for the overlapping days in the sum. Your datediff needs to be more restrictive:

declare @FromDt date

,@ToDt date

set @FromDt = '2013-01-01'

set @ToDt ='2014-01-30'

SELECT name, SUM(DaysActive)...

WhiteLotus (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Quick question, by disabling it do you mean make it do nothing, make it disappear from the...

where DateAdded<=@ToDt and InactivationDate>@FromDt

Thanks Simon - and agreed.

I quoted your snippet because it was a good test that highlights that those logical criteria most of the time will return TRUE or...

Not that we need to reopen old...

Also you didn't describe how one would identify contributions from withdrawals. Those are usually not interachangeable activities, so arbitrarily picking some might not make sense.

The subset sum problem is...