eobiki10 (9/12/2013)

---

I was refering to expressions and not sql. Anyway I later found out the correct one to use.

For other people who might have the same problem, the correct...

Brandie Tarvin (9/12/2013)

---

Jack Corbett (9/12/2013)

---

Brandie Tarvin (9/12/2013)

---

Ed,

Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near...

Rod at work (9/12/2013)

---

Jack Corbett (9/12/2013)

---

While it isn't ideal because it requires the report to be re-run if they change the parameter, I usually implement this with a...

Saujib (9/12/2013)

---

thank you.

I want only a particular phone for the consumer.

Each consumer can have 0 phone or more than one phone number,i want only primary phone.

similarly address, consumer...

below86 (9/12/2013)

---

I agree with Sean's version. As you have found out this is a nightmare to figure out, it may work but it doesn't make it right. I...

This doesn't necessarily answer your question, but, in my opinion, best practice is to use the full name, not the abbreviation so I'd use DATEDIFF(minute, '20100101', getdate()) not, DATEDIFF(mi, '20100101',...

Can you post your DDL?

If I understand what you are asking, it isn't possible. A foreign key must reference a primary key or unique constraint on the...

You should also be aware that SSAS is not Cluster Aware and that clustering SSAS is not a recommended practice.

There really isn't a great way of making sure that it happens only once a month. Like the others have said, truncate does the reseed automatically. I can...

This article on OUTER JOINs should be helpful to you. Even though it is for SQL Server 2000 it still applies to 2014.

Essentially you want something like this:

SELECT

...

While it isn't ideal because it requires the report to be re-run if they change the parameter, I usually implement this with a Sort By parameter on the report itself....

This blog post[/url] might help and I think is how most people looked at stats.

_nzrdb6 (9/11/2013)

---

Why would you want to add SSAS or SSRS as a feature of a database engine instance as opposed to creating a new instance on the same box. What's...

Talib123 (9/12/2013)

---

One thing I never encountered is corruption of a db. It makes me nervous for some reason just thinking about.

Currently I backup and restore a few main production dbs...

Brandie Tarvin (9/12/2013)

---

Ed,

Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the...