krypto69 (5/18/2015)

---

Hi,

I have this query that produces duplicates. I am trying to filter out based on the duplicate 'member address id' .

I tried using max(member address id) but that isn't...

Ask the system administrator?

naga.rohitkumar (5/18/2015)

---

I tired to check by using this command and we can see the time changed but not who changed

[ the servers is " 10.50.4000.0SP2Standard Edition (64-bit)] in version.

USE [database]

GO

SELECT...

Michael L John (5/18/2015)

---

Jeff Moden (5/18/2015)

---

andrew gothard (5/18/2015)

---

Jeff Moden (5/14/2015)

---

This one is actually true.

Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that...

naga.rohitkumar (5/16/2015)

---

yes i have followed this but not working and its throwing errors

our environment has 2008 and 2005 sqlservers and they are standard versions in that case how can...

Eirikur Eiriksson (5/17/2015)

---

For fun and furthering on Luis's answer, this examples brings back all primes between 10 and 100 using except.

😎

USE Test;

GO

SET NOCOUNT ON;

/*

For fun only,...

Jeff Moden (5/16/2015)

---

There is very little difference between editions of SQL Server according to what a Noob should start with. About 8 months ago I interviewed a handful of...

Jeff Moden (5/16/2015)

---

Nah... we all take turns learning from each other. To coin a phrase, "I learn from you, you learn from me, and people learn from us and...

Jeff Moden (5/15/2015)

---

Lynn Pettis (5/15/2015)

---

Jeff Moden (5/14/2015)

---

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before...

Jason A. Long (5/15/2015)

---

WOW... I could have sworn that the last time I tested, CASTing from a DATETIME to a DATE made it unsargable...

Just tetested with this...

DECLARE

@BegDate DATE...

ScottPletcher (5/15/2015)

---

Lynn Pettis (5/15/2015)

---

Jason A. Long (5/15/2015)

---

Both good points... Although I'd still put this in the "good idea not to do this" category as opposed to the "never do this"...

Jason A. Long (5/15/2015)

---

The following is what I'd put in the NEVER do category...

WHERE CAST(t.SomeDateTime as DATE) BETWEEN @BegDate and @EndDate

Actually... I should say "Never do again" category... I have...

Some people are...

briancampbellmcad (5/15/2015)

---

I'm not sure what you mean by a 'drive' on the server... all I can get to is \\belmont\c$ and the \\belmont\Databases\Data which is where I see BCCrestore.mdf and...

Jason A. Long (5/15/2015)

---

Out of curiosity, why do you say this?

I could see it it you were talking about DATETIME data...