http://technet.microsoft.com/en-us/library/dd239373.aspx

please send DDL and elaborate your question.

use merge statement to achieve the required .

For more detail

http://technet.microsoft.com/en-us/library/bb510625.aspx

or

http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/

Lynn Pettis (8/23/2012)

Curious, this doesn't even...

Create table type.

http://msdn.microsoft.com/en-us/library/ms175007.aspx

and use that as output parameter

check For IO of disk.

table def

table

(

price int,

typeofpen varchar (20)

)

query

-----

,WITH Temp AS

(MAX(price ) OVER(PARTITION BY typeofpen) AS price

FROM

table

)

SELECT SUM(mx) FROM temp

only way

please refer below link

http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/

You can use order by in sub query with TOP 100 PERCENT as sub query is treated as inline view

IE:

SELECT * FROM Tbale

WHERE ColumnName IN

(SELECT TOP...

indexed view works fine with static data (non changing data).

if your dimension changes frequently drop and create index .

use in build stored proc

sp_depens .

more details

http://msdn.microsoft.com/en-us/library/ms189487.aspx

provide full detail

Plz read

http://www.sqlmag.com/article/c3/store-rtf-data-in-a-sql-server-database

For SQL Server 2005 and up, use VARCHAR(MAX) / NVARCHAR(MAX) if you're dealing with pure text files (like source code or CSV files), or VARBINARY(MAX)...

Plz send bcp query