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. ...

If you ever need to do it again. Wouldn't you would like to be prepared? The problem in here is the cursor going row by row instead of doing it...