The primary key is usually the same as the clustered index but that's not a rule. They're both independent as the process to define them is different. The primary key...

MMartin1 (1/27/2015)

---

Luis Cazares (1/27/2015)

---

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column > REPLACE(...

If it's a string column with underscores between each part of the date. This could be an option.

SELECT columns_to_return

FROM dbo.XYZ

WHERE date_column > REPLACE( CONVERT( char(10), DATEADD(YY,...

No, you're confusing primary keys with the PRIMARY filegroup.

Primary Keys need to be unique. PK_AIMS_Preop index is the index that supports your PRIMARY KEY constraint that should be shown in...

What I mean is that your ReportColumns column violates the first normal form that indicates:

A relation is in first normal form if the domain of each attribute contains only...

What stops you from normalizing the ReportDefinition table?

I'm not sure that it doesn't matter as I discovered when testing a function in this thread:

http://www.sqlservercentral.com/Forums/FindPost1531822.aspx

The best option that you have is to test both approaches. I'd do it...

Carlo Romagnano (1/27/2015)

---

Raghavendra Mudugal (1/27/2015)

---

actually I was doing the same...

Why do you believe that you need to use DISTINCT? You already have a GROUP BY.

Are you seeing the same date 3 times? If so, that's normal because you're "concatenating"...

I've never used Mulesoft. After I read your post, I googled it and it seems interesting. However, I can't give a suggestion based on experience.

Steve Jones - SSC Editor (1/23/2015)

---

Jack Corbett (1/23/2015)

---

Steve Jones - SSC Editor (1/21/2015)

---

So....

What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme...

I'll say that this would be slower because you're still using a single transaction and you're using several queries. This is a guess and I might be wrong.

I believe that you don't need PIVOT, you need UNPIVOT. And you might want to use UNION ALL instead of UNION.

There's a third alternative which is explained in here by...

Could you post your sample data as insert statements? I tried to help you but I'm missing columns that you used in your query for which you didn't supply any...

mw112009 (1/22/2015)

---

I mean I know how to get that by going through the menu and drilling down , right click and select "SCRIPT...."

That's not what I really want. ...