My mind-reading capabilities are lacking today, so please state your question here.

By the way, questions end with a question mark (?)

Is this a blog post, or do you have a question?

Like this?

SELECT CONVERT(VARCHAR(10), GETDATE(), 101);

Formatting of DATE and DATETIME columns for cosmetic reasons should be left to the client & not performed in SSMS.

• This reply was modified 6 years, 5 months ago by Phil Parkin.
• This reply was modified 6 years, 5 months ago by Phil Parkin.

Does this work?

SELECT COUNT(*) / COUNT(DISTINCT p.postid)
FROM postlinks p;

SSIS assumes a default length of 50 for CSV columns. You need to increase that ... do you need help in understanding how to do that?

you need to run the SSIS Service

This is not correct. The SSIS service does very little, in fact, and is not required for package execution. Have a read here...

I think you need to use FINDSTRING().

FINDSTRING(nomchamps, "Administra",1) > 0

should work.

So ... you think that 'calculations and filling temp tables' are not DML?

Sounds like you have little choice. But I'm surprised that a new manager would go to the effort of changing something which was working fine (based on what you've said)....

How can this be achieved as ?*2 doesn't work.

With nearly 9000 points, you should be able to do better than this.

Hi Jeff, I've had some trouble getting your demo working on my home PC.

I installed 32- and 64- bit ACE drivers and then ran this:

sp_configure 'show advanced...

I see no output.

Is this a question?

OK, then try

CAST(coalesce(completeddate,lastsaveddate,receiveddate) as DATE)

TIMESTAMP columns cannot be converted to times. What is the data type of...