Then use CASE WHEN:

...

WHERE CASE WHEN DateTimeInterval = 'mm'

...

Dynamic sql.

Minnu (1/25/2013)

---

Hi Team,

Please suggest the best join to get the records(avioiding duplicates)

am having 20 joins.

if particular record is not there in that table, then it should not join that table,...

leesider (1/24/2013)

---

Actually it's OK. The records go into the table in the proper order so when I do a simple select without an "order by" clause, they come back in...

Any error returned?

Anyway, whenever you are using date strings, make sure they are in non-locale dependent format. Best is ISO:...

Whenever you want to see records in tables selected in the specific order, you should apply ORDER BY.

Actually, you cannot enforce the order of how data is stored physically on...

you need to learn how to use OUTER JOIN's (LEFT or RIGHT)

SELECT t1.col1, t2.col2

FROM table1 AS t1

LEFT JOIN table2 AS t2

ON...

And OP only wanted to sort his SELECT...

😉

But on this forum we do love to go dip! :hehe:

Merry Christmas to everyone 😀

kapil_kk (12/22/2012)

---

But all the columns on which you are suggesting to creating indexes, all are PK in their respective tables and as per my concern when we creating a PK...

Phil Parkin (12/21/2012)

---

Eugene Elutin (12/21/2012)

---

Phil Parkin (12/21/2012)

---

In...

Phil Parkin (12/21/2012)

---

In SSMS Object Explorer, go...

If your values potentially may contain separator characters then you have two choices:

use more complex multi-character separator, for example ~^~. (very often used practice eg. for BCP) or...

I think it will.

Why you don't have any WHERE condition? Do you really intent to bring all fact records?

You outer join to your dimensions on their legacy keys. So...

You can do it in SSRS.

Create a chart and select your series. Right-click series and select Series Properties.

Select Border. You can use function for setting different line styles.

Abu Dina (12/21/2012)

---

Then that's normal application behaviour I'm afraid.

If you want SQL Server to retain your comments within the stored procedure then you need to include the comments within...