ekkaldevi.naveen (7/22/2014)

---

Hi,

Already I posed the execution plan. There is only one table with 70 columns and only 1 primary key (with 12 columns). Apart from that there is no other...

You can pass selected values as comma separated string. With below method, you can insert only selected values to table.

DECLARE @weekdaySelected NVARCHAR(50)

DECLARE @tableT TABLE

( ClassName NVARCHAR(10),

WeekdaySelected NVARCHAR(50))

SET @weekdaySelected =...

+1

MysteryJimbo (7/22/2011)

---

I would have guessed the easiest answer is the page size would be a legacy from the engine's Sybase days.

Why Microsoft havent changed this or implemented adaptive pages sizes...

Easy one, thanks 🙂

Great question, thanks for sharing

Eirikur Eiriksson (7/14/2014)

---

The answer depends, the default framing of a window function varies depending on the function. As an example, the first_value function has the default framing of rows between...

Sorry I got the answer. Issue resolved.

Ian C0ckcroft (7/14/2014)

---

Hi guys, I am loading a dimension using a distinct query.

There are duplicates coming through and the only differnce is a trailing space on one of the columns.

RTRIM...

+1

You have not mentioned SQL2000 anywhere in the thread. Also you have posted this question in 2008 forum.

Don't you think you need to...

Give it a try:

; WITH AccountCTE AS (

SELECT fs_accno, fs_cost_center, fs_amount from accutn_det

)

SELECT fs_accno,[205produ],[206produ],[208produ], COALESCE([205produ], 0)+ COALESCE([206produ], 0)+ COALESCE([208produ],0) AS Total FROM AccountCTE

PIVOT (SUM(fs_amount) FOR fs_cost_center IN ([205produ],[206produ],[208produ])) p

Please check folder rights. It seems folder doesnt have required rights.

Deepak Burkul (7/11/2014)

---

Thank you......

yes this is interview question and i am going to learn more on execution plan of SQL server that time i get this confusion about Physhical Join...

Add Cost center (fs_cost_center) in Group by clause.