I don't see anything that requires an UNPIVOT.  What are your expected results?

Are you trying to create an EAV table?  That's highly discouraged.

Drew

During original and followup posts, the checkbox for “Notify me of follow-up replies via email” should default to being checked. Most people (especially newbie original posters) want to be...

It's a BAD idea and you really need to have a compelling reason...

The old forum used to BOLD threads that had unread posts/replies and it also had a link to take you directly to the last unread post.  It's much harder to...

I'm seeing bullets now.

Something like the following:

SELECT *, DATEDIFF(HOUR, LAG(attendance_date) OVER(PARTITION BY EmployeNo ORDER BY a.attendance_date), attendance_date)
FROM #tmp_employees
CROSS APPLY ( VALUES( CASE WHEN Attendence = 1 THEN [Date] END )...

You've been around long enough to know that that's not the way to present data.  You need to supply a script that will create a (temp) table or declare a...

For clarification, a SQL column does not have to be all the same type: SQL has a type of sql_variant that is designed to handle different data types in...

It's not fixed.  I'm using Chrome (73.0.3683.86), and it doesn't show the bullets or the indentation.  I also checked IE (11.592.17134.0) and it doesn't show the bullets, but it does...

Joe, Suppose that on SQL server we have 5 databases. When a schema groups database objects, do all those objects have to be within the same database? Or can...

I posted something with a bulleted list, and it didn't retain the bullets.  I tried converting to use the BBCodes for ul/li, and it still didn't work.

Also, there doesn't seem...

A database is not a spreadsheet.  You can't do a simple transpose like you can in Excel.

• Databases are strongly typed, but Excel is not.

  • Database fields all have to...

• This reply was modified 7 years, 6 months ago by drew.allen. Reason: Fixing formatting issues
• This reply was modified 7 years, 6 months ago by drew.allen. Reason: Trying to fix formatting issues. The bullet items aren't being retained

I think this will work, but it is COMPLETELY UNTESTED.  I took out one of your ISNULLs, because I don't think it is necessary with this change, and I also...

Why do you believe that SSMS is treating it as a date time?  I see no reason that it should.  It would help if you can give us some sample...