Giorgio, no problem. Glad to hear that.

@ Remi: It sometimes helps to be slow.

>Remi Gregoire

...

>Posts: #3002

Too late for that as well it seems.

Edit: And turned to 3003 while I was posting this.

SELECT DISTINCT Customer_Id

FROM Test_LastBilledTable x

WHERE Customer_Id NOT IN ( SELECT Customer_Id FROM Test_LastBilledTable WHERE Last_Billed_Date > DATEADD(d, -60, GETDATE()) )

This should work:

[Sales to Referrals Ratio] = SUM(CASE WHEN PRODUCTS_SOLD_1 '' THEN 1.0 ELSE 0.0 END) + SUM(CASE WHEN PRODUCTS_SOLD_2 '' THEN 1.0 ELSE 0.0 END) / COUNT(*)

A commit has nothing to do with writing to data files. A commit is only written to the transaction log. Then when a checkpoint occurs, the transactions older than the...

Why not simply have two columns in the table, one for storing the time the entry was created and the other when the entry was reviewed. Then have your process...

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'foobar'

Joel Spolsky has a great article that discusses why Hungarian notation is stupid. Or rather the Hungarian notation as it was recommended (and used) by Microsoft, which is not at...

I don't think it would help much with a sticky, but as a response for inadequately formed questions there are good links.

How to ask questions the smart way -...

Unless the operating system will be needing a lot of memory (it normally does not) you should go with option 3. And you will of course also need to activate...

Hungarian notation in the way it was recommended by Microsoft (it is no longer recommended) is wrong in every way and has always been. That goes for general programming and...

There is a known issue ehere the counters are not seen if Performance Monitor is open while you start SQL Server. Close Perfmon and restart SQL Server, then run Perfmon...

Well I think you will find several good overviews at Microsofts SQL Server 2005 sites. However, in my opinion, these are some of the important new features in SQL Server...

Np. What issue was that?

With the data you provided, this should work:

SELECT x.intStudent1ID, x.intStudent2ID

FROM tblSiblings x

INNER JOIN tblSiblings y

  ON x.intStudent1ID = y.intStudent2ID

 AND x.intSiblingID < y.intSiblingID