Did you follow these steps?

https://msdn.microsoft.com/en-us/library/cc280547.aspx

sharonsql2013 (5/18/2015)

---

Is it possible to join based on conditions

I am trying to join Project_Code with Manager.Code but if the project_code is blank then it should look for Project_CostCenter and Join...

There's different ways to handle this, but if you had a Originating_key and Destination_key columns in your fact table, you would have to deal with changing dimensions.

I would either update that calendar table so it does identify holidays, or create a Holidays table.

Luis Cazares (5/15/2015)

---

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle,...

Eric M Russell (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase,...

Grant Fritchey (5/15/2015)

---

Alvin Ramard (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2,...

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift,...

Here's an interview question:

Name 10 of the parameters for DBCC TimeWarp. 😛

I'd seriously consider asking a DBCC TimeWarp question at an interview, just to see how the person would...

atlantageorgia123 (5/12/2015)

---

SELECT

ProductSkuTypeId = pst.[ProductSkuTypeID],

ProductSkuTypeName = pst.[Name],

p.ProductTaxCodeID,

Here i am trying to write a case statement.

like when the skutypename is Fab by default i have to set Tax Code as A_CLTH_FAB

like when...

You could try something like:

CASE...

In your JOIN statements, try using the LEFT function instead of SUBSTRING to see if it will run any faster.

Sean Lange (5/5/2015)

---

minimay (5/5/2015)

---

nevermind i figured it out

Declare @Julycount int

Set @Julycount= (Select Count(*) From orders Where MONTH(OrderDate) = 7)

print 'The total orders for july is...

SQLRNNR (5/4/2015)

---

Luis Cazares (5/4/2015)

---

Do you realize that you posted almost the same answer...

Pricing for SQL Server can be confusing.

I would contact my local Microsoft sales office for the answer.