I'd go for the redesign as well. It's not a major one.

Take out the Workflow field from the Project table and have another table called ProjectWorkflow which would be something...

Straightforward enough question but, as it's a DATETIME you will actually get 1900-01-01 00:00:00.000 as the result.

I knew doing that 70-462 would come in handy one day.

Interesting that over 40% of answers are for a DMV that doesn't even exist :blink:

But having done that, isn't it just

UPDATE #MyTable

SET ROUNDEDMEASURE = ROUND(MEASUREMENT,NOOFDECIMALS);

At the moment over 300 people have got this one wrong. They will have learned something useful from the question (presumably that both MAXs are independent) and, as such it...

I suggest you read some of the posts...

First thing to do is be consistent with what you are calling your weeks. They start odd as "Week 44" and "Week 45" but you're pivoting on "Week44" and "Week45".

I knew the CS vs CI "default" point would be raised as soon as I read the question.

However, as the only different answer you get with a CS environment wasn't...

Seems to be one where the people who didn't think about it found it easy (see some of the comments above) whilst those who dug a bit deeper stood quite...

Excel does not have as many data types as SQL Server so won't be able to store most of them without conversion.

This article shows how they are mapped.

So you'd replace the whole thing with

UPDATE Product SET Product_Code = Left(Product_Code,ProductID) + '-Altered';

That's still a really weird thing to do though. What is the Left(Product_Code,ProductID) bit supposed to do?

You make a valid point but it reminds me of the...

doug.davidson (10/24/2013)

---

Good to know of the function exists but I still find it more useful to subtract, as this function only returns date; not date and time. I program in...

I was hunting for the option which said

Recite the rhyme:

30 days hath September,

April, June and November,

All the rest have 31,

Excepting February alone.

Which has but 28 days clear

And 29 in...

In the UK the legal minimum is 28 days including public holidays. Many companies offer a week more than that and give additional holiday to longer-serving employees. This does not...