They're different operators, they both do different things.

If you're talking of unpivoting using cross apply or union all. The...

Not entirely safe, but it could work.

SELECT *

FROM #Work

ORDER BY ISNULL( Activitycode, NCHAR(4600));

m.rajesh.uk (5/23/2016)

---

Hi All,

I need a query to get the data on hourly wise. Below query gives data on day basis.

SELECT

stat_date AS "date",

DATEPART(YEAR,stat_date) AS year,

SUBSTRING(CONVERT(VARCHAR(10),stat_date,102),0,8) AS year_month,

DATEPART(MONTH,stat_date) AS month,

DATEPART(WEEK,stat_date) AS week,

MAX(nb_error)...

Crashing

Ed Wagner (5/20/2016)

---

Luis Cazares (5/20/2016)

---

Tomorrow there's a SQL Saturday in Atlanta and I can't attend. I'll miss the opportunity to meet Jason B and Wayne S.

I'll probably have to wait...

Tomorrow there's a SQL Saturday in Atlanta and I can't attend. I'll miss the opportunity to meet Jason B and Wayne S.

I'll probably have to wait for next year or...

TheSQLGuru (5/20/2016)

---

Luis Cazares (5/20/2016)

---

This should fix the concurrency problems, and a few pet peeves I have.

WITH cte AS (

SELECT o.*,

...

average Joe

Ed Wagner (5/20/2016)

---

Luis Cazares (5/20/2016)

---

Thank you, Alan.

This has become simpler each time. It's even better now that I...

Lynn Pettis (5/19/2016)

---

Steve Jones - SSC Editor (5/19/2016)

---

drew.allen (5/19/2016)

---

Would it be possible to limit posts based on the number of visits? I noticed that most of the spam comes...

Thank you, Alan.

This has become simpler each time. It's even better now that I have templates for the...

I wouldn't want to write 99 columns, so I would use a dynamic approach for this.

DECLARE @sql nvarchar(max);

WITH

E(n) AS(

SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

),

cteTally(n) AS(

...

Just to be sure, because it's a common confusion. Are you using SQL Server?

In your post you mentioned autoincrement instead of identity (which is the word used in SQL Server)....

This should fix the concurrency problems, and a few pet peeves I have.

WITH cte AS (

SELECT o.*,

ISNULL((SELECT...

Try this:

http://blog.sqlauthority.com/2014/11/29/sql-server-customization-of-new-query-in-sql-server-management-studio/