Bhuvnesh,

CROSS APPLY (

VALUES(High, 'High', DATEPART(dw, CAST(DateID AS CHAR(8))))

,(Low, 'Low', DATEPART(dw, CAST(DateID AS CHAR(8))))) a (Val, Type, weekday)

GROUP BY...

If you can add a identity column to your table then ...you can write code like this...

---------------------------------

create table test(

id int identity(1,1),

currency_to varchar(3),

currency_from varchar(3),

tradedate datetime,

traderate decimal(27,7)

)

go

insert into test(currency_to, currency_from, tradedate, traderate)

select...

If you have permission to execute xp_cmdshell then you can use SQLCMD for the same.

thanks,

Saurabh

ok......Got it thanks....:-)

You can use Sqlcmd to save result in file..

Check your execution plan, and Find out any bulk data movement by the thickness of line.

Otherwise change in join order of tables in query may solve your issue..

Cheers

-Saurabh

You can check your procedures with profiler to find out paining areas.

Include recompilation event in profiler to find out any recompilation..

-Cheers

Saurabh

Question must be checked before posting ...

Answer is based on nchar while question is based on nvarchar..