I visited the following URL also.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23669048.html

I have seen the below code

Insert into TableA

SELECT *

FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\Temp\;Extended properties=Text')...FileName#csv

But i asked my...

rbarryyoung,

Thanks for your idea ! I will ask .NET guys. Meantime i read the following URL.

http://www.sqlservercentral.com/Forums/Topic380386-61-4.aspx

But as you said, It won't work out from UI side. Am i correct ?...

will writetext work out here ? I may wrong...But just i was thinking...

rbarryyoung,

can you share your ideas here ?

Can you tell me how it can be done ? Acutally i am not aware of .NET side, so if you give me idea, i will start my work.

Jack,

Actually, in UI there is one list box. It containts the name of the file, once user choose a filename from the list box, those file has t o be...

Any inputs ?

Oh....what a small mistake i did ? Sometime small problem may eat our brain.

Select top 12 as_of_dt,max(png_tm)as png_tm,

It is working fine now.

Thanks Steve !

one of the reason is

optimizer will have to search the column names and its data type from the system table. It will take some extra overheard.

Steve,

Control Panel - My Posts is retreiving my current year posts only. Can you please let me know how to search my old posts ?

Chris and Adrian,

Thanks for your help !

Meantime i found one way to do it. But i have used more CONVERT function. I think mine will leads to performance issue. I...

DECLARE @Parameter VARCHAR(255)

SELECT @Parameter = 'Part#1,PartName1,1|Part#2,PartName2,2|Part#3,PartName3,3'

SET @Parameter = ','+STR_REPLACE(@Parameter,'|',',') +','

DECLARE @GroupCount INT

--===== Suppress the auto-display of rowcounts to keep them from being ...

CREATE TABLE #test

(

CustID int,

id int

)

INSERT INTO #test

SELECT 100,1200 UNION ALL

SELECT 100,1201 UNION ALL

SELECT 600,1233 UNION ALL

SELECT 600,1232 UNION ALL

SELECT 700,1000 UNION ALL

SELECT 700,1000 UNION ALL

SELECT 800,2001 UNION ALL

SELECT 800,2002 UNION...

I may not have explained this as well as I could have... This list (1,-1,10,-10,...) works because if you take any whole positive number and change just one digit by...