Can you confirm that you are using a UNC path (\\server\share\...) and NOT a drive letter (X:\data\...) ?

Sounds a bit too damp for my liking. 'Whet' is the word I think you were looking for...

A possible alternative is iff(), which can be used in a SELECT:

select iif(datename(weekday,...

Fernando Margueirat-273899 (11/19/2015)

---

Phil Parkin (11/19/2015)

---

Jack (11/18/2015)

---

I remember reading an article that tested this with many thousands of records and there was a material impact. Since then I have always...

Jack (11/18/2015)

---

I remember reading an article that tested this with many thousands of records and there was a material impact. Since then I have always used the more efficient...

drew.allen (11/19/2015)

---

I actually tried to create a test on SQL 2012 (don't have SQL 2014 available) and when I tried to create the unique constraint, it failed saying that it...

If you create a unique index on GroupID & PayorID, does that fix it?

Shudder.

Error? Or message box?

I tested it this morning and it worked perfectly.

Try with an Excel file on your local hard disk. Maybe you have some network or permissions issues going...

Follow the link in my post and you can take it from there.

Fernando Margueirat-273899 (11/18/2015)

---

Thanks for this great tip!

One small change that I would make to avoid the "DR.EndDate+1" part and still be able to easily link to dates in other...

SQLBlimp (11/18/2015)

---

Phil Parkin (11/18/2015)

---

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't this...

Jack Corbett (11/18/2015)

---

jasona.work (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Brandie Tarvin (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize...

You can't, as far as I know. It's stored in encrypted form.

eavesdm (11/18/2015)

---

Good stuff. It should be coded better, though, perhaps; given the international audience and user-base and the long-established international standard ISO 8601 (https://xkcd.com/1179/) shouldn't this have been written...