The answer depends on the data type of dbo.SalesHeader.OrderDate. If it's a datetime or similar then the answer is 6 as given. But if it's a varchar column then...

Even prior to SQL Server 2014 I would have recommended a Cross tab (Like I have done above). PIVOT is quite restrictive and unflexible. A Cross Tab is by far...

Pivoting is a form of aggregation though; you can't pivot you're data without aggregating it somehow. That might be using SUM, or count, but it would also be by using...

I want to know how I will do it directly via Query so that it shows me the contents of the entire table where I can modify the...

You can't put leading zeros on a numerical datatype, but you can on a (n)varchar. One method is using RIGHT:

RIGHT(REPLICATE('0',7) + CONVERT(varchar(7),YourNumericalColumn),7)

This assumes all values are positive.

Visual Studiom and SSMS, only being 32bit really confuses me. it honestly makes no sense. Especially when their "younger brother" VSCode and ADS are only available as 64bit applications.

SSMS supports all version of SQL Server that were supported at the time of it's release, and sometimes is given compatibility for newer versions in patches (if a new client...

Unfortunately, the problem is more related to the fact that people don't check...

Also, as a result the the behaviour, the QOTD I want to send is literally impossible to write, as the question becomes entire malformed.

I have, however, attempted to guess it'll...

looks like it might be that the web control is trying to protect against HTML injection and forcing you to double escape the backslash

it's fairly common

very similar to the...

To add context, I'm trying to submit a QOTD about Backslash (Line Continuation) behaviour and I can't, as the question content becomes "malformed" due to the Backslash (Line Continuation) characters...

Appears this "feature" only occurs in Code Snippets, however, note that the \ is missing from the line outside of the code snippet.

Will test using \\ now:

October 23, 2019 at 10:27 am

#3691268

Well, this is interesting. I'm trying to submit a new QOTD, and it *appears* that the very feature I'm trying to describe actually causes the question to become malformed when...

• This reply was modified 6 years ago by Thom A. Reason: Confirmed "feature"

Some of those are, um... unique "requirements". O.o

London has been cited several times for possible Superbowl and the new Tottenham Hotspur stadium was lauded for...