Shouldn't it be 17 hours and 42 minutes?

SELECT CAST(177/10 AS VARCHAR) + ':' + CAST(177 % 10 * 6 AS VARCHAR)

should do it.

Could you write a simple macro to create the INSERT statements in Excel and then just copy/paste them into SSMS?

With a few columns it's an easy formula, e.g.

+"INSERT INTO MyTable...

I use DQS quite a lot and those steps don't bear much relation to what you do.

1) Create/Map Knowledge Base

2) Create DQ Project

3) Run project to cleanse data

is more like...

I knew the RETURN would kick in with a value of 1 so decided that that was one row returned :crazy:

So, the people who based their answer on the documentation got it wrong, whilst those who used "real data" got it right.

Perhaps there's a lesson to be learned there.....

I did the same. Found a post by Jeff and saw 33k points and "SSC Dedicated".

Easy question 🙂

If there aren't too many of these you could copy...

geoffrey.sturdy (6/25/2013)

---

"It's also a young person's game. Once you have a family, not sure you can make those trade offs and feel good about it. "

Sorry - but I take...

Another one where the answer only holds if you have YMD Date Format. Most non-US users will get Error, Error here.

However, it's obvious that the second error is caused by...

I ran the code and got:

Msg 242, Level 16, State 3, Line 7

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

The statement...

As only 6% selected the wrong answer it must be down to not selecting three options. If you don't read the question you...

In the UK age discrimination in the workplace is now illegal and rightly so. Whilst there are clearly people who still believe that younger people are better able to adapt...

Nice to find a kindred spirit. In the past I've spent 20+ years working as an IT contractor. That's one way of utilising technical skills to achieve "manager money" but...

Sometimes it's more important to do a job you enjoy and are good at than to clibm the corporate ladder.

I'm in my 50s and am employed as a Senior...

Usually, looking up the answer first and still getting it wrong would be a cause of concern but,...