Do you know a article or blog in which this things are mention , that which column name is search in the other table.

And where can i find this NameMatchingCreteria...

So in SSAS does it match by column names ? :ermm:

Jeff Moden (5/25/2014)

---

Faster than what? Show us the links, please.

Thanks for the response Jeff....

I tried various permutation and combinations to insert the data using the below call, where N would be used in SP itself

DBO.InsertProperties '????' --Run the SP

It this actually possible at...

Hello Experts ,

I notice one more thing, That if i used N in the SP and not while calling , ???? gets inserted.

CREATE TABLE #TBL1 (Property nvarchar(255))

ALTER PROCEDURE DBO.InsertProperties(@Prop...

Yeah , i too figure out what was going wrong . If we follow SQLRNNR solution, N also gets insert. Which should not happen.

I had by mistake used N as...

I came up with the following solution

CREATE TABLE #TEMP (Value int,Type nvarchar(50),Identifier int)

INSERT INTO #TEMP VALUES(1225,'ABC', 217840)

INSERT INTO #TEMP VALUES (1225,'ABC', 121662)

INSERT INTO #TEMP VALUES (1295,'ABC', 275581)

INSERT INTO #TEMP VALUES...

Hi,

Found a piece of article written by kendra regarding Maxdop, which i think would answer your question.

http://www.brentozar.com/archive/2013/12/q-can-high-maxdop-make-a-query-slower/

Just thought of giving a Update.

The query is running with in the stipulated time.

Nothing has changed over a period of time no server settings have changed not even query...

Sean Lange (1/10/2014)

---

Stale statistics?

Parameter sniffing (or the lack of it)?

It is nearly impossible to help without some details. Please see this article from Gail about how to post performance issues....

I am trying to store the value return by the select in variable. I took that variable as varchar as well as date but nohing seems to work.....

The closes i can come to this problem is

SELECT LEFT(CONVERT(DATE,VALUE,111),7) FROM #TEMP WHERE ID=2

still it is not working. Any one who can help !!!!!!!!

Phil Parkin (12/3/2013)

---

Shadab Shah (12/3/2013)

---

I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question...

I may be wrong over here but if none index is created on the table it gets stored on heap and retrival...

Thanks once again for the reply....

But what i am trying to do is, i want to loop through

MAX( CASE WHEN rn = 1 THEN Value ELSE '' END) Option1,

MAX(...