A little more information will be helpful. 🙂

What my requirement is that today i have just one file with name MyData+<AnyDate>.xls. But there will be one file added on daily basis and I want to pick that...

Question from SQL 2005... 🙂

Dana Medley (11/6/2013)

---

Jeff Moden (11/5/2013)

---

Heck no. ...

Good QOTD for the people who have confusion over this. Though i had came with this specific condition several times so there was never a question of any confusion. 🙂

Easy...

chandan_jha18 (11/7/2013)

---

Burned my hands with heavy deletes once,...

Interesting read. Gives the pretty much idea on what you can end up into if not consider the impact of the DML.

Richard Warr (11/7/2013)

---

I knew the CS vs CI "default" point would be raised as soon as I read the question.

However, as the only different answer you get with a CS...

Thanks Beatrix, will definitely take a look into it. 🙂

Nice easy question. Specially after losing few points in recent days thanks to some mind blender questions.

Thanks steve. 🙂

Paul White (11/3/2013)

---

Well it might do,...

+100....

Gary Varga (10/31/2013)

---

GilaMonster (10/31/2013)

---

Oh, and once we have standardised tests, we get to deal with this kind of person - http://ask.sqlservercentral.com/questions/107800/i-put-3-years-experience-as-a-sql-developer-i-want.html, the kind who will cheat, will lie, will pay...

Excellent QOTD Chirag. 🙂 T.G.I.F.

Thanks for a very good question based on "orphan user" condition. I had to do lots of R&D and go through various link to gather information. Despite all that efforts...