Man

Using user-defined scalar functions (anywhere) is bad.

Exceptions are possible but thorough testing must be done to confirm that, so just keep in mind the previous sentence.

From what I understand, you're concatenating 4 values delimited by double backslashes.

Here's an option, it adds the delimiter before each value and uses STUFF to remove the first delimiter:

SELECT STUFF(...

No, you can only have an update statement within a stored procedure. UPDATE is a statement, a...

The following article will explain how to do it:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Read it and ask any questions you might have.

RonKyle (7/1/2016)

---

To that I always reply that no user should be looking...

Ed Wagner (7/1/2016)

---

Bunnies

I don't like that idea because that way you need to join tables for simple queries restricted by dates. Even if you won't have that problem once the cube is...

vijay.sap1255 (7/1/2016)

---

Dear Experts,

I was trying to get rid of null values when using full outer join between two tables. For example, I have tables like below:

Table A ...

Maybe these articles will explain this better:

https://www.mssqltips.com/sqlservertip/2650/what-maxdop-setting-should-be-used-for-sql-server/

https://support.microsoft.com/en-us/kb/2806535

This is an additional to check five settings that often go overlooked

https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/

Durga, in the Microsoft article you can find the answer.

This is equivalent to your code. Both are not guaranteed to get the same results each time as there's nothing to order. Pietlinden gave you the other part of the...

You could also check this to learn about catch-all-queries. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

I would create a different temp table for each parameter.

Maybe this simplified example from AdventureWorks can make it look simpler. The dates are both in the fact and the dimension.

CREATE TABLE [dbo].[DimDate](

[DateKey] [date] NOT NULL,

[DayNumberOfWeek] [tinyint] NOT NULL,

[DayNameOfWeek]...

You just need 1 Time dimension. That dimension can have several hierarchies to represent natural year, fiscal year, etc. The key for that dimension is a date.

In your fact tables,...

It's easy to convert a SELECT into an UPDATE.

You have 2 options depending on the complexity of the UPDATE. You can keep the FROM and use a table alias in...