Well, we usually refrain from the...

When I have a SQL question one of my DBAs can't answer (or they're not around), SQL Server Central is the first place I come. I've always gotten a quick...

A number of the questions of the day lately have been sponsored by Expert SQL Server Development, stating there would be a drawing for a copy of the book among...

None of the answers line up with what is on Microsoft TechNet for creating a proxy account. According to Microsoft, the procedure to create a proxy account is:

Credentials must be...

HAPPY BIRTHDAY, KENDALL!!!

I found the article generally interesting. As a tester, I often need to build truth tables and this tool could come in handy.

However, I've never come across the "IMPLIES" operator...

Here's another vote for an article on ALL, WITH ROLLUP and WITH CUBE. Thanks for the excellent explanation.

I would also like my points back. 🙂

I was trying to understand what the code Jeff presented was doing and ran the following queries:

I don't mind the page peel ad; it was actually sort of cool. But, I hate the double-underline thing. As a new user, it looked like a link to some...

From BOL:

Bhupesh,

I'm not entirely sure I understand your question. I think what you want is some kind of list of all the tables that have an entry for a particular employee....

David,

This link is on the blog:

http://download.microsoft.com/download/1/a/3/1a32ea84-11a3-4adf-953e-7a65b9831f5a/VSDATAD1.img

Is it not what you're looking for?

Steve

Okay, for those of us who use this site to learn about SQL server, how did you do it?

I believe Amit's logic is reversed. This works:

select A.PhoneNumber, A.Call_Time, B.Call_Time, A.Minutes, B.Minutes

from Table1 A inner join Table2 B

ON A.PhoneNumber = B.PhoneNumber

where

(DateDiff(ss,A.Call_Time,B.Call_Time)  Between -60 AND 60)

and

((A.Minutes - B.Minutes) BETWEEN...